Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

DISTINCT COUNT not visualizing accurately

Hi there,   I am working on a report for our social services division and they want to see demographics of distinct program participants. When I create this using the COUNT (DISTINCT) function usin...
Need Help
  • v-frfei-msft's avatar
    v-frfei-msft
    7 years ago

    Hi Anonymous ,

     

    I think this is by default. As there should be some same IDs for different Demographic in your data. So aiming to get the correct result, we should create a measure based on [Distinct].

     

    Distinctcorrect = sumx(your table, [Distinct])

    If the issue still occur, kindly share your pbix to me. Please upload your files to One Drive and share the link here.

     

    Regards,
    Frank

v-frfei-msft's avatar
v-frfei-msft
Icon for Community Support rankCommunity Support
7 years ago

Hi Anonymous ,

 

Assuming your data looks like that. And I created relationship between two tables based on Demographic. I create a measure to get the distinctcount of category. 

 

distincount = DISTINCTCOUNT(Table2[category])

After new another measure.

 

Measure = SUMX(Table2,[distincount])

Please refer to the results as the picture below. If your data is not like this, Could you please create a sample and share the data to me. You can upload the files to One Drive and share the link here.

Regards,

Frank