Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hello,
I have many sliders where I can set a percentage value. Here are "just" three of them:
To set the increment and the range of percentage I use the parameter functionality inside PBI:
ParameterValue = GENERATESERIES(0, 1.55, 0.05)
I use this to create a useful measure, which I can multiply whith other measures of interest:
Parameter Value Output = SELECTEDVALUE('ParameterValue'[ParameterValue])
And here I can use it to multiply with e.g. the Order Amount from machines which are painted green:
MachineNumberScenario =
Calculate(Distinctcount(Orders[Ordernumber_No]), Orders[Ordertype] = "GreenMachine")*ParameterValue[ParameterValue]
I created a KPI Visual, where I can play scenarios where I forecast when I got 50% more orders than normal coming in. So I can see the numbers, if machine orders goes up to 150% over baseline.
Now my problem occurs when I have several sliders, which have subset of each other.
For example I have one KPI window with the above Measure "MachineNumberScenario", but also have a second KPI Window with a subset of that value:
MachineNumberScenario2 =
Calculate(Distinctcount(Orders[Ordernumber_No]), Orders[Subtype] = "RedPlate")*ParameterValue2[ParameterValue2]
The subtype= "RedPlate" are Machines with a Redplate. Some of the green machines have a red plate.
So the second slider also should influence the first KPI Window when I set the slider to different values other then 100%, it should show me the MachineNumberScenario based on the two sliders. For example when I set the ParameterValue1 to 50% and the ParameterValue2 to 100% it should forecast the number of machine, when only 50% green machine are being produces, but the red machine staying stable at 100%. When the parameter values are being set reversely, it should forecast as if the greem machine are staying stable at 100%, but what is the total number when the machines with red plate are going down 50%?
How to bring the measures and parameters together to make sense? Whatever I did so far I got wrong values especially when the the slider values are not 100%. And several sliders can influence a KPI.
Thank you very much in advance.
Best.
Solved! Go to Solution.
The default way filters work is they are "stacked" on top of each other, as if you would say "AND". This is true for individual columns, for tables, and for the entire data model. For example Ordertype = GreenMachine AND Ordersubtype = RedPlate
What you seem to want is an "OR" filter where you append conditions like Ordertype = GreenMachine OR Ordersubtype = RedPlate
That is not something Power BI supports natively, you will have to implement that entirey through measures that you then use as visual filters.
The default way filters work is they are "stacked" on top of each other, as if you would say "AND". This is true for individual columns, for tables, and for the entire data model. For example Ordertype = GreenMachine AND Ordersubtype = RedPlate
What you seem to want is an "OR" filter where you append conditions like Ordertype = GreenMachine OR Ordersubtype = RedPlate
That is not something Power BI supports natively, you will have to implement that entirey through measures that you then use as visual filters.
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
64 |
User | Count |
---|---|
135 | |
120 | |
101 | |
71 | |
61 |