Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreShape the future of the Fabric Community! Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions. Take survey.
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] ) ) )
Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.
User | Count |
---|---|
92 | |
91 | |
84 | |
80 | |
49 |
User | Count |
---|---|
146 | |
137 | |
109 | |
68 | |
55 |