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!To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.
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