Good day,
I have two tables, one has 1 category and the other one has all the categories. Is it possible to create a measure that will divide per category and divide each category to the total of all categories for the table that has few categories.
Example below, the colored rows would be the totals and the non colored rows are the categories.
I need both totals to interact. Is this possible?
@jayp01 , If you divide by total category
divide([Measure], calculate([measure], removefilters(Table[Category])) )
Hi, amitchandak
Thanks for the help, tested the measure but doesn't provide the output I'm looking for.
Expected output should be 9.5% from (388,058 / 4,077790)
Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!
User | Count |
---|---|
124 | |
76 | |
69 | |
54 | |
53 |
User | Count |
---|---|
191 | |
104 | |
83 | |
79 | |
78 |