Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

How to do a double DISTINCTCOUNT?

Hello everyone, My table follows this structure: Item Code Class FFF 15.1 A FFF 16.1 B YYY 15.1 A YYY 15.1 A YYY 20.1 A XXX 16.1 C As you can see, an item can...
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • Ashish_Mathur's avatar
    Ashish_Mathur
    5 years ago

    Hi,

    This measure works

    =SUMX(SUMMARIZE(VALUES(Data[Item]),Data[Item],"ABCD",DISTINCTCOUNT(Data[Code])),[ABCD])

    Hope this helps.

jthomson's avatar
jthomson
Solution Sage
5 years ago

If you just do a distinctcount on the Code column, then stick the Item column as rows in a matrix, it should give you the results you want?

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi jthomson 
I'm sorry, I didn't understand the matrix part. Would that be a measure created?