Dynamics Measures in matrix depending of filter

[MarMarone]

Hi all!

I have a problem, in my model I only have 2 tables (Calendar and Table1), In my filter at year I choose Year = 2022 in my matrix i want to show 3 or 4 measures, ¿is possible?

I have this measure (works) but only applied with one measure.

[Anonymous]

Hi @MarMarone ,

If you want to return two results by selecting "2022", you could combine two measures' results as text type.

You can modify it as follows

Measure =
VAR Selection =
    SELECTEDVALUE ( 'Table_Name'[Row] )
RETURN
    SWITCH (
        TRUE (),
        Selection = "2022",
            [Total_Sales] & "," & [Total_SalesPY],
        Selection = "2021", [Total_Negative],
        Selection = "2020", [Total_Gross]
    )

Note: After adding double quotes, your "2020", "2021", "2022" are in text format.

Best Regards,

ShundaSteph

[lbendlin]

Read about Field Parameters.  They allow you to shape your matrix according to your requirements, both for dimensions and for measures.