Forum Discussion
Solved
Getting some measures from Count Distinct with two row header fields
Hi friends! I've got a Matrix with two row headers fields and i need to get the result of divide one columm by another (Both are distinct count fields). For example: In green the two ro...
Hi marcss44
Here is the report back with the measures https://drive.google.com/file/d/1j6eHxkYc6gBObIRkU3jd218izWoEa_7r/view?usp=sharing
Joe
Hi marcss44
I will presume that 3 by 4988 should be 3 by 49883?
Lets create some measures to get the sum of each column
IDS Total = SUM(TABLE[IDS TOTAL])
ID SCRAP = SUM(Table[ID SCRAP])
We will now create a measure that gets the Total of IDS Total that removes filters.
IDS Total - All =
CALCULATE([IDS Total], /// we use the first measure
ALLEXCEPT(Table[Familia])
)
Now lets calculate the division
% of IDS Total =
DIVIDE([ID SCRAP], [IDS Total], 0)
Convert to % if needed
Joe
This part is not working:
IDS Total - All = CALCULATE([IDS Total], /// we use the first measure ALLEXCEPT(Table[Familia]) )
The ALLEXCEPT says: Not enought arguments...