Forum Discussion

acg's avatar
acg
Icon for Resolver I rankResolver I
4 years ago
Solved

Custom-made table with multiple measures ?

I like to ask whether the follwing is possible to do and where I need to search for a solution:   I need to be able to present / list a number of items in a clean overview table, whereby consecutiv...
  • amitchandak's avatar
    amitchandak
    4 years ago

    acg , If the rows are also split of measure. You need to use the calculation group for this year, last year, and change %

     

     

    example

     

    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))

    diff = [This Year]-[Last Year ]
    diff % = divide([This Year]-[Last Year ],[Last Year ])

     

    Calculation Groups- Measure Slicer, Measure Header Grouping, Measure to dimension conversion. Complex Table display : https://youtu.be/qMNv67P8Go0

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

acg , If the rows are also split of measure. You need to use the calculation group for this year, last year, and change %

 

 

example

 

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))

diff = [This Year]-[Last Year ]
diff % = divide([This Year]-[Last Year ],[Last Year ])

 

Calculation Groups- Measure Slicer, Measure Header Grouping, Measure to dimension conversion. Complex Table display : https://youtu.be/qMNv67P8Go0