Forum Discussion

herwet's avatar
herwet
Frequent Visitor
4 years ago

Combining multiple measures into one column chart.

Hi,  I have an issue I have been struggling with.  The case is:  I am making a KPI report and want to measure Gross Profit per region divided by workforce per region in the different sectors.   ...
Need Help
Tips and Tricks
amitchandak's avatar
amitchandak
Super User
4 years ago

herwet , I will use measure like

 

Sales AMS 2021 = CALCULATE(sum('Workforce'[Workforce]), 'Workforce'[JC KEY] = "HC2000",, Workforce[Region] = "AMS" , filter( 'dim_date' , 'dim_date'[Year] = max( 'dim_date'[Year]) ) )

 

example

//Only year vs Year, not a level below

This Year = CALCULATE(sum('Table'[Qty]),filter(ALL('Date'),'Date'[Year]=max('Date'[Year])))
Last Year = CALCULATE(sum('Table'[Qty]),filter(ALL('Date'),'Date'[Year]=max('Date'[Year])-1))

 

You can also check calculation groups Calculation Groups- Measure Slicer, Measure Header Grouping, Measure to dimension conversion. Complex Table display : https://youtu.be/qMNv67P8Go0