Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hello everyone,
I have a matrix visualization which contains 8 months data. When I select the month in slicer, I get the data I want to show. But, when I apply TopN filter the %age calculated measures aggregates the values on the basis of TopN and shows aggregated values on the basis of the top N instead of showing the values with respect to entire data.
Eg:
Branch Qty Sales %GT Sales
A 10 100 1.11
B 10 1000 11.11
C 10 2000 22.22
D 10 5000 55.56
E 10 900 10
My Filter of TopN is by Qty for top3
I want to show:
Branch Qty Sales %GT Sales
B 10 1000 11.11
C 10 2000 22.22
D 10 5000 55.56
But
the column %GT values changes and shows as :
%GT Sales
12.5%
25%
62.5%
----------
100%
How can I show the topN values as they are on overall and not on the basis of top3.
Thanks a lot for any help!
Regards,
Rahul
Solved! Go to Solution.
@rahuldas_vgm in this case, there is workaround, you can create a table having topN values
in this case, we have assumed you want to have only top3 value which you can change as per your needs
then in your visual, you can apply a filter to show only topN values, below is the expected output
Proud to be a Super User!
Hi,
Could you share the download link of your PBI file?
Hi, @rahuldas_vgm ;
You can just create a measure, as follows:
Measure = SUM([Sales])/SUMX(ALL('sales_tab'),[Sales])
The final output is shown below:
Best Regards,
Community Support Team_ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@rahuldas_vgm if this resolve your problem, please accept my solution to help others.
Proud to be a Super User!
@rahuldas_vgm in this case, there is workaround, you can create a table having topN values
in this case, we have assumed you want to have only top3 value which you can change as per your needs
then in your visual, you can apply a filter to show only topN values, below is the expected output
Proud to be a Super User!
User | Count |
---|---|
86 | |
82 | |
68 | |
64 | |
55 |
User | Count |
---|---|
120 | |
99 | |
91 | |
83 | |
65 |