Hi, I know it must be simpler but I am literally stuck in this.I have the data like this
|Month||Volume in 1000Kgs|
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
Solved! Go to Solution.
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.
Community Support Team _ Eason
I thought it was a measure. Please try
= DIVIDE ( SUM ( [Volume] ), CALCULATE ( SUM ( [Volumne] ), ALL ( 'Table'[Month] ) ) )
Check out the November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.
130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.