Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Anonymous
Not applicable

SUM and Filter: One more question

‎09-01-2023 01:42 PM

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         1        0          0

Toronto               C                   1         0        1          0

Toronto               C                   1         0        0          1

Toronto               D                   1         1        0          0

Toronto               D                   1         1        0          0

Toronto               D                   1         1        0          0

Ottawa                A                   1         0        1         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? 

 

Labels:
Message 1 of 3
216 Views
0
1 ACCEPTED SOLUTION
parry2k
Super User
Super User

‎09-01-2023 02:16 PM

@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

Message 2 of 3
190 Views
2 REPLIES 2
parry2k
Super User
Super User

‎09-01-2023 02:16 PM

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

Message 2 of 3
191 Views
Anonymous
Not applicable
In response to parry2k

‎09-01-2023 04:12 PM

parry2k,

 

Thank you very much for your help.

Message 3 of 3
172 Views
0

Helpful resources

Announcements
Sept PBI Carousel

Power BI Monthly Update - September 2024

Check out the September 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

Sept NL Carousel

Fabric Community Update - September 2024

Find out what's new and trending in the Fabric Community.

View All