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.
I am having one table from there I want to fetch top 10 customer and bottom 10 customer in one visual.
Solved! Go to Solution.
Hi,
I tried to create a sample pbix file like below. (top3 and bottom3 show up together).
Please check the picture and the attached pbix file.
I hope the below sample can provide some ideas on how to create a solution for your datamodel.
Sales measure: =
SUM( Data[Sales] )
top three and bottom three measure: =
VAR _topthreelist =
SUMMARIZE (
TOPN ( 3, ALL ( Data[Customer] ), [Sales measure:], DESC ),
Data[Customer]
)
VAR _bottomthreelist =
SUMMARIZE (
TOPN ( 3, ALL ( Data[Customer] ), [Sales measure:], ASC ),
Data[Customer]
)
VAR _unionlist =
UNION ( _topthreelist, _bottomthreelist )
RETURN
CALCULATE ( [Sales measure:], KEEPFILTERS ( _unionlist ) )
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
Hi,
I tried to create a sample pbix file like below. (top3 and bottom3 show up together).
Please check the picture and the attached pbix file.
I hope the below sample can provide some ideas on how to create a solution for your datamodel.
Sales measure: =
SUM( Data[Sales] )
top three and bottom three measure: =
VAR _topthreelist =
SUMMARIZE (
TOPN ( 3, ALL ( Data[Customer] ), [Sales measure:], DESC ),
Data[Customer]
)
VAR _bottomthreelist =
SUMMARIZE (
TOPN ( 3, ALL ( Data[Customer] ), [Sales measure:], ASC ),
Data[Customer]
)
VAR _unionlist =
UNION ( _topthreelist, _bottomthreelist )
RETURN
CALCULATE ( [Sales measure:], KEEPFILTERS ( _unionlist ) )
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
Thank You.
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 | |
97 | |
77 | |
63 | |
55 |
User | Count |
---|---|
143 | |
109 | |
89 | |
84 | |
66 |