Solved: Re: SUM and Filter: One more question

Anonymous · ‎09-01-2023

Similar as the question I asked yesterday. But it is different:

Table

------------------------------------------

City Computer Count I II III

Toronto C 1 1 0 0

Toronto C 1 0 1 0

Toronto C 1 0 0 1

Toronto D 1 1 0 0

Ottawa A 1 0 1 0

Ottawa B 1 0 0 1

-------------------------------------------------------------

Using matrix, In the report page, we can get the following table

City Computer Sum of Count Sum of I Sum of II Sum of III

-------------------------------------------------------------------------------------

Ottawa A 2 0 2 0

Ottawa B 1 0 0 1

Toronto C 4 2 1 1

Toronto D 3 3 0 0

------------------------------------------------------------------------------------

Total 10 5 3 2

Now I need the new measure is:

2/3= 67%,

1/3=33%,

4/7=57%,

3/7=43%

This time we sum(count) by city, Toronto =7, Ottawa = 3.

Then calculate Count/Sum.

How to make this ratio?

parry2k · ‎09-01-2023

@Anonymous use this measure:

Count Ratio = DIVIDE ( [Sum Count], CALCULATE ( [Sum Count], ALLSELECTED ( Computer[Computer] ) ) )

Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤

Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

View solution in original post

parry2k · ‎09-01-2023

@Anonymous use this measure:

Count Ratio = DIVIDE ( [Sum Count], CALCULATE ( [Sum Count], ALLSELECTED ( Computer[Computer] ) ) )

Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤

Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

Anonymous · ‎09-01-2023

parry2k,

Thank you very much for your help.

SUM and Filter: One more question

Helpful resources

Join us at the Microsoft Fabric Community Conference

Power BI Monthly Update - February 2025

Fabric Community Update - February 2025

How to Get Your Question Answered Quickly

Join us at the 2025 Microsoft Fabric Community Conference