Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Counting filtered results gets duplicate values

Hi eveyrone. I'm having an issue where after I filter some dollar values, I'm getting duplicate counts.  As you can see in the photo, the dollar values are filtered by the amounts but quite a few of them are saying "True". This would obviously give me more than the total amount of the documents that I actually have. Here is the formula for the filters:

 

 "to_500 =
CALCULATE(
DISTINCTCOUNT('Tablename'[DOCUMENT]),
'tablename'[Value] <= 500
&& 'Tablename'[Value] > 0)  "

 

 



 

 

Any help would be appreciated.

 

Thanks

Need Help

2 Replies

  • v-piga-msft's avatar
    v-piga-msft
    Icon for Resident Rockstar rankResident Rockstar
    7 years ago

    Hi Anonymous ,

    By my tests based on your image and your formula, I cannot reproduce your issue.

    The measure is created with aother formula. You also could have a try with it.

    Measure =
CALCULATE (
    DISTINCTCOUNT ( Table1[Document] ),
    FILTER ( 'Table1', 'Table1'[Value] <= 500 && 'Table1'[Value] > 0 )
)

    In addition, please check if you have install the latest version of Power BI Desktop 2.68.5432.841.

    If you still need help, please share your data sample as table format and your desired output so that we could help further on it.

    Best Regards,

    Cherry

     

  • v-piga-msft's avatar
    v-piga-msft
    Icon for Resident Rockstar rankResident Rockstar
    7 years ago

    Hi Anonymous ,

    Have you solved the problem?

    If you have solved, please always accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.

    If you still need help, please feel free to ask.

    Best Regards,

    Cherry