Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi everybody, I'm trying to Filter a virtual table by Ranking position, the number of positions visualized by the users are chosen from a slicer generated from a What-if parameter. This is my Dax expression:
Solved! Go to Solution.
@camilocorralesg , hope Ranking is an independent table with set on number to filter, else use what if parameter
https://docs.microsoft.com/en-us/power-bi/transform-model/desktop-what-if
small change
var agentss = filter(SUMMARIZE(ALL(fct_hotel_revenue),[agent],"__Rank",[Rank], "Income", [Income]), [__Rank] <= <= SELECTEDVALUE(Ranking[Ranking]) )
var agentss___ = SELECTCOLUMNS(agentss, "agent", [agent])
var filterss =
RETURN
CALCULATE([Income], FILTER(fct_hotel_revenue, fct_hotel_revenue[agent] IN agentss___))
Thanks!
@camilocorralesg , hope Ranking is an independent table with set on number to filter, else use what if parameter
https://docs.microsoft.com/en-us/power-bi/transform-model/desktop-what-if
small change
var agentss = filter(SUMMARIZE(ALL(fct_hotel_revenue),[agent],"__Rank",[Rank], "Income", [Income]), [__Rank] <= <= SELECTEDVALUE(Ranking[Ranking]) )
var agentss___ = SELECTCOLUMNS(agentss, "agent", [agent])
var filterss =
RETURN
CALCULATE([Income], FILTER(fct_hotel_revenue, fct_hotel_revenue[agent] IN agentss___))
User | Count |
---|---|
50 | |
23 | |
18 | |
18 | |
14 |
User | Count |
---|---|
91 | |
84 | |
39 | |
25 | |
21 |