Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
I have two slicers. One slicer is SUM(A) and the other one is SUM(B)
What i want is to filter using the condition
SUM(A) > Userenteredvalue OR SUM(B) > UserEnteredvalue2
I want two values which the user of the dashboard will be able to input. If it's not possible i can use the greater than slicer option but still want the user selected value in the slicer to be taken in the expression.
Hi, @Anonymous
According to your description, I think you can use the GENERATESERIES() function in DAX to create two new calculated tables in custom to place into a vale range slicer to slice the data, you can try my steps:
Slicer = GENERATESERIES(1,999999999,1)
Slicer2 = GENERATESERIES(1,999999999,1)
More info about the GENERATESERIES() function in DAX
Thank you very much!
Best Regards,
Community Support Team _Robert Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@Anonymous , I think you can use what if the parameter for that
measure =
var _val = maxx(allselected(whatif), whatid[param])
return
sumx(values(Table[id]) , if(sum(Table[A]) >_val, Sum(Table[A]),0))
you need to group data at a level to filter measure (values, id)
https://docs.microsoft.com/en-us/power-bi/desktop-what-if
Thank you for the response, however I am quite new to powerbi.
I saw the whatif parameter but it only allows values upto 9999. My numbers can go in billions since it is a amount i am dealing with.
So lets say the range of a particular value lies from 0 to 999,999,999
and i want sum of only those values which lie above 100,000 it doesn't seem to work.
Can you guide me if at all possible
@Anonymous , you can use generate series and create manual parameter. but equal to value is only available with what if
https://docs.microsoft.com/en-us/dax/generateseries-function
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
94 | |
82 | |
66 | |
58 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |