The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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