Forum Discussion
Use value to calculate another value
I'm trying to do all of my calculations in PowerBI rather than having to dump it to Excel and do my calculations. I need to calculate a percent of a total. The base number (denominator) is the w...
You may take a look at the following post.
https://community.powerbi.com/t5/Desktop/Subtotal-Percentages/m-p/313658#M139139
This is close, but not fully what I'm looking for.
In my example, there are a total of 50 GRAPES. 12 of those grapes are RED SEEDLESS GRAPES. This is 24% of the total of 50 GRAPES. How would you have Power BI calculate that?