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

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
Parul_verma
Frequent Visitor

How to create measure for Volume (in 1 000 KGS) of 1 SKU/Volume (in 1 000 KGS) of all SKU?

Hi, I know it must be simpler but I am literally stuck in this.I have the data like this

MonthVolume in 1000Kgs
jan100
feb200
mar300

I want the result to be shown as,100/600 for jan,200/600 for feb,300/600 for mar.Please get me the solution for this

1 ACCEPTED SOLUTION

All selected (item) worked as comparison to this, this is showing me the exact values in col B

View solution in original post

7 REPLIES 7
v-easonf-msft
Community Support
Community Support

Hi, @Parul_verma 

If you just want to display as 100/600 in January, 200/600 in February, and 300/600 in March, then what you might want to create is a Text measure like the following:

Result = 
VAR a =
    SUM ( 'Table'[Volume in 1000Kgs] )
VAR b =
    CALCULATE ( SUM ( 'Table'[Volume in 1000Kgs] ), ALL ( 'Table' ) )
RETURN
    a & "/" & b

If you want the result to be a calculated value, you can also consider checking 'show value as percent of grand total' to display the result.

veasonfmsft_0-1666249371468.png

Best Regards,
Community Support Team _ Eason

All selected (item) worked as comparison to this, this is showing me the exact values in col B

tamerj1
Super User
Super User

Hi @Parul_verma 

please try

=
DIVIDE ( [Volume], CALCULATE ( [Volumne], ALL ( 'Table'[Month] ) ) )

not working I am unable to take volume column without any function under calculate

Hi @Parul_verma 
I thought it was a measure. Please try

=
DIVIDE ( SUM ( [Volume] ), CALCULATE ( SUM ( [Volumne] ), ALL ( 'Table'[Month] ) ) )
lukiz84
Memorable Member
Memorable Member

Hi,

 

"shown" where? In a measure or in a calculated column?

In a measure 

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

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

Top Kudoed Authors