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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

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
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.