Forum Discussion

arimoldi's avatar
arimoldi
Resolver II
2 years ago
Solved

Line and Stacked Column Chart - Trend Line Percentage

Hi,   I want to insert a card/table that shows the percentage of increase/decrease of the trend line in a stacked column chart:     in this case there is a difference from 65 to 49, so 16 ...
Need Help
Tips and Tricks
  • arimoldi's avatar
    arimoldi
    2 years ago

    I got it:

     

    (CALCULATE ( COUNT ( Table[Element] ), ALLSELECTED(Table[Element]), MIN(Table[Date])= EE_FINDING_H[REFERENCE_DATE]
    ) - CALCULATE ( COUNT ( Table[Element] ), ALLSELECTED(Table[Element]), MAX(Table[Date])= Table[Date]
    )) / (CALCULATE ( COUNT ( Table[Element] ), ALLSELECTED(Table[Element], MIN(Table[Date])= Table[Date]
    ) ) * 100
     
    Hope it could helps others!
     
    Thanks,
    Andrea
     
arimoldi's avatar
arimoldi
Resolver II
2 years ago

I got it:

 

(CALCULATE ( COUNT ( Table[Element] ), ALLSELECTED(Table[Element]), MIN(Table[Date])= EE_FINDING_H[REFERENCE_DATE]
) - CALCULATE ( COUNT ( Table[Element] ), ALLSELECTED(Table[Element]), MAX(Table[Date])= Table[Date]
)) / (CALCULATE ( COUNT ( Table[Element] ), ALLSELECTED(Table[Element], MIN(Table[Date])= Table[Date]
) ) * 100
 
Hope it could helps others!
 
Thanks,
Andrea