Forum Discussion

tuncay's avatar
tuncay
Icon for Helper III rankHelper III
3 years ago

Total is not shown on Matrix

Dear Community,

 

I have a measure added to a matrix. When the slicer selection is only one (e. g. 2023) it does calculate a total in the matrix. But whenever I select two years it does not calculate the total anymore..

 

Berechnet ACT = SUMX(FILTER('RD Costs', 'RD Costs'[Fiscal Year] = 'SP - Fiscal Year - Master data'[Selected_Fiscal_Year]),[ACT YTD])

 

 

Thank you very much!

Need Help

4 Replies

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      HI tuncay,

      I'd like to suggest you replace the '=' operator(it not suitable to compare with multiple of selected values) to 'IN' operator and use values to extract and get distinct selection list:

      Berechnet ACT =
SUMX (
    FILTER (
        'RD Costs',
        'RD Costs'[Fiscal Year]
            IN VALUES ( 'SP - Fiscal Year - Master data'[Selected_Fiscal_Year] )
    ),
    [ACT YTD]
)

      Regards,

      Xiaoxin Sheng