Forum Discussion
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 row header fields, and i need to obtain the division of 8 by 49883 and 3 by 4988
Hi marcss44
Here is the report back with the measures https://drive.google.com/file/d/1j6eHxkYc6gBObIRkU3jd218izWoEa_7r/view?usp=sharing
Joe
7 Replies
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...
Sorrry my mistake, It should work with this now
IDS Total - All = CALCULATE([IDS Total], /// we use the first measure ALL('Table'))
Ok, can you share a sample of your data with all column names visible?
Hi marcss44
Here is the report back with the measures https://drive.google.com/file/d/1j6eHxkYc6gBObIRkU3jd218izWoEa_7r/view?usp=sharing
Joe
