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 ,

 

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Hi v-frfei-msft ,

     

    I cannot share my pbix as the data involves PII. Since the field containing the demographic data does not allow for multiple values, I am not sure how as you said "be some same IDs for different Demographic in your data". 

     

    To be clear, did your measure mean to be formatted like this?

     

    Distinctcorrect = SUMX('My_table_name', [UniqueID])

     

    If so, that did not work. If I misinterpreted what you wrote, feel free to clarify. Thanks.