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'm trying to create a TopN slicer where the user can define how many instances to display. I found an earlier thread posted on this forum but that thread is referring to another measure for the sum portion of the problem. I'd like to refer to a data field already included in the data table I'm bringing into Power BI:
Link to old thread: https://community.powerbi.com/t5/Community-Blog/Dynamic-TopN-made-easy-with-What-If-Parameter/ba-p/3...
Created Measure from old thread:
TopN City =
VAR SelectedTop = SELECTEDVALUE('TopN'[TopN])
RETURN
SWITCH(TRUE(),
SelectedTop = 0, [Sales Amount],
RANKX (
ALLSELECTED( 'Orders'[City] ),
[Sales Amount]
)
<= SelectedTop,
[Sales Amount]
)
In the measure above, [Sales Amount] is a created measure. In place of it, I would like to refer to a specific data field 'Claim Data Pull'[Paid].
My question is, is that possible? Is there a way to manipulate the measure to sum 'Claim Data Pull'[Paid] in place of [Sales Amount]?
Solved! Go to Solution.
As long as Claim Data it connected with City
TopN City =
VAR SelectedTop = SELECTEDVALUE('TopN'[TopN])
RETURN
SWITCH(TRUE(),
SelectedTop = 0, calculate(sum('Claim Data Pull'[Paid])),
RANKX (
ALLSELECTED( 'Orders'[City] ),
calculate(sum('Claim Data Pull'[Paid]))
)
<= SelectedTop,
calculate(sum('Claim Data Pull'[Paid]))
)
if you need more help make me @
Appreciate your Kudos.
As long as Claim Data it connected with City
TopN City =
VAR SelectedTop = SELECTEDVALUE('TopN'[TopN])
RETURN
SWITCH(TRUE(),
SelectedTop = 0, calculate(sum('Claim Data Pull'[Paid])),
RANKX (
ALLSELECTED( 'Orders'[City] ),
calculate(sum('Claim Data Pull'[Paid]))
)
<= SelectedTop,
calculate(sum('Claim Data Pull'[Paid]))
)
if you need more help make me @
Appreciate your Kudos.
Thank you so much.
Thank you,
Andrew
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 |
---|---|
114 | |
99 | |
83 | |
70 | |
60 |
User | Count |
---|---|
150 | |
115 | |
104 | |
89 | |
65 |