topic Re: How to create measure for Volume (in 1 000 KGS) of 1 SKU/Volume (in 1 000 KGS) of all SKU? in DAX Commands and Tips

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

Parul_verma — Sun, 16 Oct 2022 13:38:08 GMT

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

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

lukiz84 — Sun, 16 Oct 2022 17:45:39 GMT

Hi,

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

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

Parul_verma — Sun, 16 Oct 2022 17:52:43 GMT

In a measure

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

tamerj1 — Sun, 16 Oct 2022 20:03:37 GMT

Hi Parul_verma

please try

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

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

Parul_verma — Mon, 17 Oct 2022 06:13:47 GMT

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

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

tamerj1 — Mon, 17 Oct 2022 07:18:14 GMT

Hi Parul_verma
I thought it was a measure. Please try

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

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

v-easonf-msft — Thu, 20 Oct 2022 07:06:06 GMT

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

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

Parul_verma — Sat, 22 Oct 2022 01:00:24 GMT

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