Forum Discussion
Solved
What If Parameter
Hi Everyone,
I was able to learn the What If Parameter with a Single Value, but I am unable to use the Between and other options. I am learning this for the 70-788 Exams. Analyzing and Visualizing Data Using Power BI
Hi Hashiru ,
One sample for your reference. Here we can create mesures to work on it.
between = CALCULATE(SUM('Table'[value]),FILTER('Table','Table'[value]>=Parameter1[Parameter1 Value] && 'Table'[value]<=Parameter2[Parameter2 Value]))above = CALCULATE(SUM('Table'[value]),FILTER('Table','Table'[value]>=Parameter2[Parameter2 Value]))PBIX as attached.
2 Replies
I will like to have an example on the use of What If Parameter and the Between Option, Greater than or Equal to
Thanks
Hi Hashiru ,
One sample for your reference. Here we can create mesures to work on it.
between = CALCULATE(SUM('Table'[value]),FILTER('Table','Table'[value]>=Parameter1[Parameter1 Value] && 'Table'[value]<=Parameter2[Parameter2 Value]))above = CALCULATE(SUM('Table'[value]),FILTER('Table','Table'[value]>=Parameter2[Parameter2 Value]))PBIX as attached.
