Getting some measures from Count Distinct with two row header fields

[marcss44]

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

[Joe_Barry]

Ok, can you share a sample of your data with all column names visible?

[marcss44]

Yeah of course:

https://drive.google.com/file/d/1fx3J5lh2PvtSr5Wv2yT6tRqVVH6Xz-se/view?usp=sharing

[Joe_Barry · Accepted solution]

Hi @marcss44 

Here is the report back with the measures https://drive.google.com/file/d/1j6eHxkYc6gBObIRkU3jd218izWoEa_7r/view?usp=sharing

Joe

[Joe_Barry]

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

[marcss44]

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...

[Joe_Barry]

Sorrry my mistake, It should work with this now

IDS Total - All = 
CALCULATE([IDS Total], /// we use the first measure
ALL('Table'))

[marcss44]

No, is not working:

8/49883 it shows 100%