Forum Discussion

chiru5262's avatar
chiru5262
Icon for Helper III rankHelper III
2 years ago
Solved

Distinct Filter not giving the result expected

Below is my issue when I do distinctcount on 'assetnum' the total is 4145, but when I seperate them by filter BM/CM the count total is 2020+2425  which is 4445 which doesnt match with 4145. I did ex...
Need Help
chiru5262's avatar
chiru5262
Icon for Helper III rankHelper III
2 years ago

Hi mickey64 

 

That makes sense, but how can I acheive 7, as I need the output of 7 for my case.

 

appreciate your help

 

Thanks,

Chiru

lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
2 years ago

You need to materialize the individual calculations via SUMMARIZE or SUMMARIZECOLUMNS  if you want the DISTINCTCOUNT by category rather than across categories.

  • chiru5262's avatar
    chiru5262
    Icon for Helper III rankHelper III
    2 years ago

    lbendlin  thanks for your response, could you please send me the dax measure I can use for the above.