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

Hi I have had a look at your pbix and I have to say I was a little confused in your dax that you shared you were counting names, now you say counting items?   

 

Besides that though, what i realised was what you are actually asking is about the total?  so the measure works correctly howevever the total is wrong, please just clarify that that is what you are asking?

 

In the dax you provided it is very thorough, however because it is slighly different to what you presented here, I need to make sure I understand what you are asking?

 

ie would this be the same dax query?

NameCount4 =
IF([100k-]<>0,
CALCULATE(
DISTINCTCOUNT(CompanyNameLookup[Correct Company Name])
)
)

 

is the seven presented here what you are referring to?

 

 

 

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hello vanessafvg ,

 

That is correct under my 100K- Dax when I try to obtain the correct name count I do not obtain the proper count since it is also counting the blanks. Yes the NameCount4 was my initial failed attempt at obtaining the correct Dax Count. Sorry for the confusion yes it is a name count I am looking for but I added an index count to the table just to see if that would make the calculation any easier but I guess not. Sorry for the late reply!