The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
hello everyone, i have created a field parameter for closer and opener,
i made measure based on selected measure i want with SWITCH and all is working fine,
but i cant use topn for one specific column because it will affect the other,
this is the measure i made
Chart Margin Selected Measure Reps = SWITCH(
[Selected Rep],
"Closing Rep",COUNTX(FILTER('Reps Measures','Reps Measures'[Reps Measures Order] =0),'Reps Measures'[Reps Measures]),
"Opening Rep",COUNTX(FILTER('Reps Measures','Reps Measures'[Reps Measures Order] =0),'Reps Measures'[Reps Measures])
)
here is the field parameter for measures
and here is result
so how can i show top 5 closers if i select closing reps, and top 5 openers when i select opener reps??
@eliasayyy , the measure you are using needs to be a TOPN Measure
TOPN: https://youtu.be/QIVEFp-QiOk
TOPN with Numeric Parameter -https://youtu.be/cN8AO3_vmlY?t=26448
User | Count |
---|---|
27 | |
12 | |
8 | |
8 | |
5 |
User | Count |
---|---|
31 | |
15 | |
12 | |
11 | |
7 |