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

[Parul_verma]

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

Month	Volume in 1000Kgs
jan	100
feb	200
mar	300

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

[v-easonf-msft]

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.

Best Regards,
Community Support Team _ Eason

[Parul_verma · Accepted solution]

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

[tamerj1]

Hi @Parul_verma 

please try

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

[Parul_verma]

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

[tamerj1]

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

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

[lukiz84]

Hi,

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

[Parul_verma]

In a measure