Hi Amit, will you please be able to attach the twbx file ?
Your Avg Subscriber Revenue calc is an aggregate. Therefore it is a measure and always be a measure.
Because of that, ASR Grouping is based on an aggregate, and therefore is also an aggregate and always will be a measure.
But looking at the first calc, I think you can redo it as a FIXED LOD. And if you do, then it is NOT an aggregate, and therefore the ASR Grouping will also not be an aggregate.
To make the FIXED LOD, the SUM half of your calc will be one FIXED LOD, and the COUNTD half will be another. You can combine those two LOD strings into one calc if you want. Otherwise make two separate ones, and make a third calc that divides the two.
I think You dont need to convert ASR grouping into dimension. If you want the total 398 of countd customers, simply remove the customer ID pill from row and put the COUNTD(customer ID) in text. I just mocked up a calculation below. if you still wan the customerid pill in rows, you may want to use subtotal on columns
ofcourse I need to create the LOD's but need to figure it out well. I will try out ans post the solutions in here.
thank you so much for taking time to help me resolve. However this being an aggregated calculation the stated solution dosent work.