Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
how to show top 3 total product sales and sales of the top 3 on all years?
i will be able to display the top 3 total sales
example
Prod Total
-a 1000
yr1 998 <- yr2 = 1 and yr3 = 1 dont display cause it is not on top3 on those 2 years
-b 800
yr2 800
-c 750
yr1 700
yr3 50
is it possible to display it even though it is not part of top3 on those 2 years?
Solved! Go to Solution.
Hi @Jinxz_21 ,
Based on your information i assume your table data looks similar to below .
So, you can write the measure like below and place it in the visual filter in matrix and make it as 1,
Please accept it as a solution if it satisfy your requirement. Thanks.
Hi @Jinxz_21 ,
Based on your information i assume your table data looks similar to below .
So, you can write the measure like below and place it in the visual filter in matrix and make it as 1,
Please accept it as a solution if it satisfy your requirement. Thanks.
Hey @Jinxz_21 ,
I'm missing the following information, what data is there and what do you want to visualize.
Consider creating a pbix file that contains sample data but still reflects your data model (tables, relationships, calculated columns, and measures). Upload the file to onedrive, googledrive, or dropbox and share the link.
Regards,
Tom
User | Count |
---|---|
124 | |
108 | |
99 | |
62 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |