Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I need to moltiply the numbers inside a table selecting the multiplier from a "slicer" and also able to select the steps
ex: 10.1, 10,2, 10,3 ...etc
I have a table with the total revenue and i want calculate the margin selecting the value (%) from slicer
Can you help me?
Solved! Go to Solution.
Go to Modelling > New Parametr > Numeric Range and make sure to use "Add a slicer to this page". Your users can then use a slicer to select the percentage multiplier.
I have insert thie new column:
#Column = VALUE('Forecast (Billing)'[Billing])*'Autodesk New'[Autodesk New Value]
I don't understand what you mean. Can you explain to me what do you want to do with the new column?
many thanks it works
I have other 2 questions
1) How can i make a moltiplication between the slider value and existing value?
2) Can i set the default value reading a measure?
1. You create a measure in which you multiply every value with the value from the slicer.
2. What do you mean by setting default value reading a measure? Usually, you can take the minimum or maximum value of the slicer as default value.
1. Ok
2. I would like to set the default value coming from other measure calculated
In the measure of the paramter table you have the following formula
can anyone answer to my questions?
Go to Modelling > New Parametr > Numeric Range and make sure to use "Add a slicer to this page". Your users can then use a slicer to select the percentage multiplier.
User | Count |
---|---|
106 | |
88 | |
81 | |
76 | |
73 |
User | Count |
---|---|
112 | |
103 | |
96 | |
74 | |
67 |