Total is not shown on Matrix

[tuncay]

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!

[tuncay]

any ideas?

[Anonymous]

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

[tuncay]

[Anonymous]

Hi @tuncay,

Can you please share some dummy data that keep the raw data structure with expected results and dax expressions that your used? It should help us clarify your scenario and test to coding formula.

How to Get Your Question Answered Quickly  

BTW, this error message metions you are try compare two different type of values. Please double check on your expression at the two side of operator to confirm these field values are in the same data type.

Regards,

Xiaoxin Sheng