Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
So I want to create a "Percent/Divide"measure for each category from the Grand Total.
But my visual are coming up with different "Percentage" numbers
Here are my measures I've created?
Am I missing something?
Is my measure not correct?
Thanks for any help coming my way
Solved! Go to Solution.
The [Sold Revenue Total] measure is calculating the total for the currently filtered category. If you want to calculate the grand total you would need to do
Veggie % =
DIVIDE (
[Sold veggies rev],
CALCULATE ( [Sold revenue total], REMOVEFILTERS ( 'Table' ) )
)
The [Sold Revenue Total] measure is calculating the total for the currently filtered category. If you want to calculate the grand total you would need to do
Veggie % =
DIVIDE (
[Sold veggies rev],
CALCULATE ( [Sold revenue total], REMOVEFILTERS ( 'Table' ) )
)
Now I see what I did wrong, Thank you for very much for the help!
What is the measure for [Sold revenue total]?
What is the structure of you rmodel? Which fields are you using (from which tables) for Veggies and Fruit?
Depending on how the model is structured, you need a measure along the lines of
% over total veggies and fruit =
VAR _Revenue =
SUM ( Table[Revenue] )
VAR _All =
CALCULATE (
SUM ( Table[Revenue] ),
ALL ( 'Veggie Table'[Veggie] ),
ALL ( 'Fruit Table'[Fruit] )
)
RETURN
DIVIDE ( _Revenue, _All )
This should work for both the veggie and fruit visuals (but again it depends on how the modelis structured and which fields you are using)
Proud to be a Super User!
Paul on Linkedin.
My model is setup pretty simple.
I will hold on to this measure for my more extensive visuals.
Thanks for your help
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 40 | |
| 38 | |
| 36 | |
| 29 | |
| 28 |
| User | Count |
|---|---|
| 127 | |
| 88 | |
| 78 | |
| 66 | |
| 65 |