Custom Total

[Chandrash12]

Hello All,

I have table where each month have a measure with distinct count but row total is also in distinct count. However the Row total should be summation of distinct count accros 4 months. How do i change rwo totals only

[v-xiaosun-msft · Accepted solution]

Hi @Chandrash12 ,

It is because that when a Measure is used on rows in a table, the column total for those rows is not calculated based on a sum of the results in the rows, but instead it calculates using the same Measure formula and applies it to the total of the data selected.

You can try to create measures like below to get the correct totals.

IF(COUNTROWS(VALUES([Option 1]))=1,[MEDIUM],SUMX(VALUES([Option 1]),[MEDIUM]) 

Or

IF(HASONEFILTER([Option 1]),[MEDIUM],SUMX(VALUES([Option 1]),[MEDIUM]))

Best Regards,
Community Support Team _ xiaosun

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[VahidDM]

Hi @Chandrash12 

It's a common and happened a lot.
Please check this link and you will find the solution:
https://www.vahiddm.com/post/why-my-measure-returns-the-wrong-total

If this post helps, please consider accepting it as the solution to help the other members find it more quickly.

Appreciate your Kudos!! 

LinkedIn | Twitter | Blog | YouTube