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 calcula...
Need Help
tuncay's avatar
tuncay
Icon for Helper III rankHelper III
3 years ago

any ideas?

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

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

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      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