Forum Discussion

Pikachu-Power's avatar
Pikachu-Power
Impactful Individual
5 years ago

dynamic column name in complex matrix

hi all,   i have a complex matrix in a following form:     The measures are dynamic in dependence of a quarter filter and are like:   Measure1 = VAR _SelectedMeasure = SELECTEDVALUE (...
Need Help
Icey's avatar
Icey
Community Support
5 years ago

Hi Pikachu-Power ,

 

It is not supported to create dynamic meausre name.

You can try to create a new table with all measure names needed via "Enter Data". For example:

 

Sort MeasureName

1

 Plan 2021
2 FC I 2021
3 FC II 2021
4 FC III 2021
5 Plan 2020
6 FC I 2020
7 FC II 2020
8 FC III 2020
... ...

 

Then, create a measure to replace "Measure1" in your table visual like so:

Measure 1 - 1 =
VAR SelectedYear =
    SELECTEDVALUE ( 'Table'[Year] )
VAR SelectedQuarter =
    SELECTEDVALUE ( 'Table'[Quarter] )
VAR SelectedMeasureName =
    SELECTEDVALUE ( 'MeasureNameTable'[MeasureName] )
RETURN
    SWITCH (
        SelectedYear,
        2021,
            IF (
                ( SelectedQuarter = "Q1" && SelectedMeasureName = "Plan 2021" )
                    || ( SelectedQuarter = "Q2" && SelectedMeasureName = "FCI 2021" )
                    || ( SelectedQuarter = "Q3" && SelectedMeasureName = "FCII 2021" )
                    || ( SelectedQuarter = "Q4" && SelectedMeasureName = "FCIII 2021" ),
                [Measure1]
            ),
        2020,
            IF (
                ( SelectedQuarter = "Q1" && SelectedMeasureName = "Plan 2020" )
                    || ( SelectedQuarter = "Q2" && SelectedMeasureName = "FCI 2020" )
                    || ( SelectedQuarter = "Q3" && SelectedMeasureName = "FCII 2020" )
                    || ( SelectedQuarter = "Q4" && SelectedMeasureName = "FCIII 2020" ),
                [Measure1]
            )
    )

 

 

 

Best Regards,

Icey

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.