Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Guys, hello!
Please help me to solve the following problem.
I want to calculate the lost profit only for products whose profit is less than the specified value in the parameter.
I created a measure:
Solved! Go to Solution.
here is the solution 🙂
@AleksandrG , to filter a measure you need to force a group by. or use measure in the visual level filter
example
suxm(filter(values(Table[Name]), [percent] < selectedvalue(whatif[value]) ), [Measure])
Hello)
Many thanks for the advice.
I'd really like to do this functionally - via Create Parameter if possible)
But is there really no way to make a filter through Create parameter - Numeric parameter?
It seems that everything is obvious, at first glance, how to implement it.)) But for some reason it does not work.
I have already started trying through creating a DAX virtual table.
Here's what happens:
If I create a virtual table without the FILTER function, then everything works as it should.
But as soon as I start filtering the table through the created parameter, the data from the chart disappears.
here is the solution 🙂
User | Count |
---|---|
97 | |
87 | |
77 | |
67 | |
63 |
User | Count |
---|---|
112 | |
96 | |
95 | |
67 | |
65 |