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 moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register 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] ) ) )
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
90 | |
86 | |
85 | |
68 | |
49 |
User | Count |
---|---|
139 | |
112 | |
104 | |
64 | |
60 |