Forum Discussion

Tome_05's avatar
Tome_05
Helper III
4 years ago
Solved

Total value is not displayed correctly

I am always grateful for your help. I have something I want to do, but I don't know how to do it, so please help me. For example, when User in image ① is set as a unique value and data is expressed...
Need Help
Tips and Tricks
  • Jihwan_Kim's avatar
    Jihwan_Kim
    4 years ago

    Hi,

    By only seeing the screenshot, I think one of the user of ja and one of the user of en is the same, so that is why total unique count of all user is four, and I think this is correct.

    However, if your business case confirms that total has to be five, because simply 3 plus 2 is 5, and If you want to show total as 5, please try to create a measure like below.

    Please check the below picture and the attached pibx fie. I tried to create a sample pbix file like below.

     

     

    fix version distinct users count measure: =
SUMX ( VALUES ( Data[Locale] ), CALCULATE ( DISTINCTCOUNT ( Data[User] ) ) )
Jihwan_Kim's avatar
Jihwan_Kim
Super User
4 years ago

Hi,

By only seeing the screenshot, I think one of the user of ja and one of the user of en is the same, so that is why total unique count of all user is four, and I think this is correct.

However, if your business case confirms that total has to be five, because simply 3 plus 2 is 5, and If you want to show total as 5, please try to create a measure like below.

Please check the below picture and the attached pibx fie. I tried to create a sample pbix file like below.

 

 

fix version distinct users count measure: =
SUMX ( VALUES ( Data[Locale] ), CALCULATE ( DISTINCTCOUNT ( Data[User] ) ) )
Tome_05's avatar
Tome_05
Helper III
4 years ago

Jihwan_Kim 

Thanks to you, I was able to solve it!
thank you very much!