Forum Discussion
Switch and Or Selectedvalue error
Hi Experts
I have a satnd alone table with
1. Actuals
2. Budgets
3. forecast - P01
or alternatovely i an trying to use the column called Dataset in my FACT Table.
I want to be able to selected from my sclier Actuals and return the sum for the Actual and select budget and return sum for budget and select Forecast - P01 and return the sum for April current FY and plus the forecasted values for the remaining 11 months. based on the filter selection
Total Dataset =
VAR _SelectorNUm = MIN('Metric Selected'[Index])
RETURN
SWITCH(_SelectorNUm
,1, [Total Financial Dataset]
,2, [Total Financial Dataset]
,3, CALCULATE([Total Financial Dataset],'Date'[Date] = DATE(YEAR('Date'[Date]),4,1)),BLANK())
Dear WhaleWatcher222, You can use Field Parameter to switch between different measures,
For exampel when you have 3 measure,
1. Actuals
2. Budgets
3. Forecast (whatever you have in your measures)
You just need to calculate Field Parameter, please review the following screenshot,
Slicer is used to presenr the selected measure.
Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!!
2 Replies
Dear WhaleWatcher222, You can use Field Parameter to switch between different measures,
For exampel when you have 3 measure,
1. Actuals
2. Budgets
3. Forecast (whatever you have in your measures)
You just need to calculate Field Parameter, please review the following screenshot,
Slicer is used to presenr the selected measure.
Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!!thanks for the reply back, My issues is that when forecast - P01 is selected - i want to show the actuals for April and forecast for the other 11 months
andWhen Forecast - p02 s selected - i want to show the actuals for April and May and forecast for the other 10 months, that is where i am stuck the other bit i agree with you.
