Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

Reply
SteelChampzz
Helper II
Helper II

What am I missing in my measure?

So I want to create a "Percent/Divide"measure for each category from the Grand Total.

SteelChampzz_2-1664984750447.png

 

But my visual are coming up with different "Percentage" numbers

SteelChampzz_1-1664984527947.png

Here are my measures I've created? 

SteelChampzz_3-1664984855103.png

SteelChampzz_4-1664984905745.png

 

Am I missing something?

Is my measure not correct?

Thanks for any help coming my way

 

 

 

 

 

1 ACCEPTED SOLUTION
johnt75
Super User
Super User

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' ) )
)

View solution in original post

4 REPLIES 4
johnt75
Super User
Super User

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!

 

PaulDBrown
Community Champion
Community Champion

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)





Did I answer your question? Mark my post as a solution!
In doing so, you are also helping me. Thank you!

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

Helpful resources

Announcements
Power BI DataViz World Championships

Power BI Dataviz World Championships

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!

December 2025 Power BI Update Carousel

Power BI Monthly Update - December 2025

Check out the December 2025 Power BI Holiday Recap!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Users online (5,239)