Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
Hi Folks,
I am looking to create an interactive filter of sorts.
The idea is the user would click the financial year data slicer at the top of the page, this is currently just a column with each financial year located in its own cell. The aim is that this would then change the rest of the Data (Achieved, Budget and Achieved %) to the correct financial year. The issue is that each data set does not have a common name, also the two Achieved Indicators are measured columns.
Is this possible or is there an easier alternative?
An example of the current Achieved code is below:
Value Achieved = VAR ProbableVal = CALCULATE (SUM( Opportunity[Revenue 2017/18] ), Opportunity[Pipeline Reporting Status] = "F) Probable", Opportunity[Status Code] = "Live" ) VAR SecuredleVal = ( SUM (Databanks[2017/18] )) RETURN (ProbableVal + SecuredleVal)
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em Português@MFelixThanks for pointing me in the right direction!
Having an issue with the formula, wondering if you could help?
I've attached the part that's causing an issue below, I that the SUM function is wrong potentially believe?
VAR SecuredleVal = CALCULATE(SUM ( SWITCH ( FYSelector[Column1] = "2017/18", Databanks[2017/18], FYSelector[Column1] = "2018/19", Databanks[2018/19], FYSelector[Column1] = "2019/20", Databanks[2019/20] ) ))
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em Português@MFelixSolved one problem and created another
Getting an error, saying it cannot determine a signal value for the FYSelector, unsure as each line has = "2017/18" and so on which, matches the value in each row.....???
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsYep, mines matches?
VAR SecuredleVal = CALCULATE ( SWITCH ( FYSelector[Column1] = "2017/18", SUM ( Databanks[2017/18] ), FYSelector[Column1] = "2018/19", SUM ( Databanks[2018/19] ), FYSelector[Column1] = "2019/20", SUM ( Databanks[2019/20] ) ) )
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsRegards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em Português
Just made a little change to the DAX
VAR SecuredleVal = CALCULATE ( SWITCH ( Values(FYSelector[Column1]) = "2017/18", SUM ( Databanks[2017/18] ), Values(FYSelector[Column1]) = "2018/19", SUM ( Databanks[2018/19] ), Values(FYSelector[Column1]) = "2019/20", SUM ( Databanks[2019/20] ) ) )
User | Count |
---|---|
117 | |
94 | |
87 | |
75 | |
64 |
User | Count |
---|---|
138 | |
112 | |
110 | |
98 | |
94 |