Forum Discussion

SimonNagy's avatar
SimonNagy
Frequent Visitor
2 years ago
Solved

Custom KPI for time-intelligence in table with adjustable time resolution

Hello All,   I've been working on a table, in which the date resolution can be changed with a parameter group from day to week to month, as follows:   At the same time, I'm trying to implem...
Need Help
Tips and Tricks
  • DataInsights's avatar
    DataInsights
    2 years ago

    SimonNagy,

     

    SELECTEDVALUE doesn't work with field parameters. Use the pattern below:

     

    VAR Selected =
    SELECTCOLUMNS (
        SUMMARIZE ( 'Parameter', 'Parameter'[Parameter], 'Parameter'[Parameter Fields] ),
        "Parameter", 'Parameter'[Parameter]
    )

     

DataInsights's avatar
DataInsights
Icon for Super User rankSuper User
2 years ago

SimonNagy,

 

SELECTEDVALUE doesn't work with field parameters. Use the pattern below:

 

VAR Selected =
    SELECTCOLUMNS (
        SUMMARIZE ( 'Parameter', 'Parameter'[Parameter], 'Parameter'[Parameter Fields] ),
        "Parameter", 'Parameter'[Parameter]
    )