I'm trying to calculate a value (%) by using one rows value as a % of the other (total of a certain type)
The total resources booked column is a count, the resource count total is the following measure:
There's multiple slicers on the page, but I just can't get the measure right to calculate the resources booked as a % of the resoure count total.
Any help appreciated. Thanks.
@Anonymous seems like you are showing different values in the visual and using different in the divide function, why you are using COUNT(Table2[Resource Name]) in the divide function?
ResourceCountTotal =
DIVIDE (
COUNT('Table1'[Type])
CALCULATE(COUNT('Table1'[Type]), ALLSELECTED('Table2'[Resource Name]))
)
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 seems like you are showing different values in the visual and using different in the divide function, why you are using COUNT(Table2[Resource Name]) in the divide function?
ResourceCountTotal =
DIVIDE (
COUNT('Table1'[Type])
CALCULATE(COUNT('Table1'[Type]), ALLSELECTED('Table2'[Resource Name]))
)
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.
As in like this?
The % calculations are incorrect, which is where I'd got to before. Complete novice, here!
@Anonymous what is the actual issue? You can divide count with the measure you show and will give you %
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.
Helpful resources
Power BI Monthly Update - July 2025
Check out the July 2025 Power BI update to learn about new features.
Join our Fabric User Panel
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Fabric Community Update - June 2025
Find out what's new and trending in the Fabric community.
