Forum Discussion

marcss44's avatar
marcss44
Helper I
2 years ago
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...
Need Help
Joe_Barry's avatar
Joe_Barry
Solution Sage
2 years ago

Sorrry my mistake, It should work with this now

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

 

 

marcss44's avatar
marcss44
Helper I
2 years ago

No, is not working:

 

 

 

8/49883 it shows 100%