Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

DAX that will Count correctly

Hello,   I have the following Dax's:         <100K = [Transfer Payments Total]-[100k+] 100k+ = SUMX ( FILTER ( FILTER ( SUMMARIZE ( 'ZZPAR2 III-9A Tr...
Need Help
vanessafvg's avatar
vanessafvg
Community Champion
5 years ago
NameCount4 = 
IF([<100K]>0,
    CALCULATE(
    DISTINCTCOUNT('ZZPAR2 III-9A Transfer Payments'[Name])
    )
)

have you tried > 0 ? 

 

can you provide sample data in text form?

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Yes I have and 18 still shows up in the total although the sum of each rows only shows 1 and 1 like in my image. Unfortunately my model has over 231,653 lines of data with sensitive information which I cannot share. I would have to replicate the issue in a similar model. I even tried with DISTINCTCOUNTNOBLANK and I get the same results