Divide values in matrix visualization by the total of the other matrix

[MA5515]

Hi, 

I have two matrix visualization which I want to divide each value from the first one by the total from the scoend one, so I do't want to group the values in the second matrix by 30,60 ,90, I want them to be exatly the same as the total  for each score class (which is the unique number of cases which I want to divide by), can anyone help on that? thanks 

  

 

[Greg_Deckler]

@MA5515 First, please vote for this idea: https://ideas.powerbi.com/ideas/idea/?ideaid=082203f1-594f-4ba7-ac87-bb91096c742e

This looks like a measure totals problem. Very common. See my post about it here: https://community.powerbi.com/t5/DAX-Commands-and-Tips/Dealing-with-Measure-Totals/td-p/63376

Also, this Quick Measure, Measure Totals, The Final Word should get you what you need:
https://community.powerbi.com/t5/Quick-Measures-Gallery/Measure-Totals-The-Final-Word/m-p/547907

Also: https://youtu.be/uXRriTN0cfY
And: https://youtu.be/n4TYhF2ARe8

[khaledHabib90]

Can you share the 2 measures inside the two matrix visuals ?

Are both coming from the same table?

Please share a sample or a screenshot of the table structure.

[MA5515]

Hi @khaledHabib90 
yes the two measures from same table, the first one is the costs which I want to divide by the total number of cases to get the average, and in the table, I have differnt costs for each case, thus I want the distinct count of those cases which showsn in matrix 2 

[khaledHabib90]

Great, try this

Newmeasure = sumofcosts / calculate(distinctcount(ActNo), Keepfilters(all(days_from_scoring)))

Did my reply help you solve your problem? If yes please accept it as a solution 🙂

[MA5515]

unfortunately, didn't work 😞

[khaledHabib90]

Try this, 

Measure = SUM('YourTable'[Costs])/ CALCULATE(DISTINCTCOUNT('YourTable'[ActNo]),ALL('YourTable'[days_from_scoring]))

Did my reply help you solve your problem? If yes please accept it as a solution