Forum Discussion

Pradgouda18's avatar
Pradgouda18
Regular Visitor
2 years ago
Solved

Using parameters within measures

Here is a detailed description of my problem.   I have financial information in multiple columns - 2024Actual, 2024 Budget, 2023 Actual, 2023 Budget, 2022 Actual, Midyearforecast1, Midyearforecast2...
Need Help
  • Pradgouda18's avatar
    Pradgouda18
    2 years ago

    Instead of using Selectedvalue(Selected2[Parameter Fields]), I used Selectedvalue(Selected2[Parameter Order]) and used the sort order. It worked.

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi Pradgouda18 ，

 

In case you are using switch, the first parameter should be added true()

Revenue1 =
SWITCH ( true(),
selectedvalue(Parameter[Parameter Fields]),
"2024Actual",[2024ActualRevenue],
"2024Budget",[2024BudgetRevenue],
Blank()
)

Revenue2 =
SWITCH (true(),
Selectedvalue(Selected2[Parameter Fields]),
"2024Actual",calculate(sum(Data[2024Actual]),Data[Cost Category] IN {"Revenue"}),
"2024Budget",calculate(sum(Data[2024Budget]),Data[Cost Category] IN {"Revenue"}),
"2023Actual",calculate(sum(Data[2023Actual]),Data[Cost Category] IN {"Revenue"}),
Blank()
)

 

Hope it helps!

 

Best regards,
Community Support Team_ Scott Chang

 

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

  • Pradgouda18's avatar
    Pradgouda18
    Regular Visitor
    2 years ago

    Thanks. I tried. This is not working