Forum Discussion

powerdev's avatar
powerdev
Regular Visitor
8 years ago
Solved

IF Distinct

Hi Team,   I work in the healthcare industry, and it is important that we obfuscate aggregated patient results if they result in <= 10.   So my viz is using a calculated measure of DISTINCTCOUNT...
  • powerdev's avatar
    powerdev
    8 years ago

    Well after fighting this for a while, I noticed that I needed to control with a between statement to avoid zero values and then everything worked fine.

     

    Solution:

    # of Patients = IF(DISTINCTCOUNT('TableName'[Patient Id]) > 0 && DISTINCTCOUNT('TableName'[Patient Id]) <= 10, 5, DISTINCTCOUNT('TableName'[Patient Id]))

    Maybe this can help someone else.

v-yulgu-msft's avatar
v-yulgu-msft
Microsoft Employee
8 years ago

Hi powerdev,

 

Based on my test, calculating Distinctcount nested in an IF function works great. But the result returned by a measure would be affected by context. 

 



 

 

It doesn't seem to do the distinct count before evaluating. Before I was returning about 20 aggregated records, when adding the code above it turns into several hundred thousand and eventually times out.

Could you show me the unexpected result you got now? Also, I need more detailed description about how to simulate a similar report as yours.

Regards,

Yuliana Gu