Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hey All,
What I want is to rank products based on a sales metric, and display that metric, sorted ascending by rank on a continuous axis.
The catch is that the fact table is at a lower intersectionality than my desired summary, and I need that summary to be reactive to selections made in slicers in the interface.
More practically, I have a table of Sales. Sales are associated to stores, products, and a calendar (by weeks).
I want to chart, by Product
The RANK of:
Productivity = CALCULATE(SUM(Sales)/DISTICTCOUNT(Stores), 'Product'[SomeFlag] = "Something") along the X (horizontal) axis
and
Productivity = CALCULATE(SUM(Sales)/DISTICTCOUNT(Stores), 'Product'[SomeFlag] = "Something") along the Y
I've managed to achieve this by creating a table:
Solved! Go to Solution.
Unfortunately, I'm not able to share my data, or a subset of my data.
I wrote my visualization in R instead.
Hi MiserFry
It is hard to understand the measure without sample data, so if possible, could you please inform me more detailed information(such as your fact table and product table)? And if you want to sort chart by measure or column’s result, you could try to use below step:
Best Regards,
Zoe Zhi
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Unfortunately, I'm not able to share my data, or a subset of my data.
I wrote my visualization in R instead.
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
64 |
User | Count |
---|---|
135 | |
120 | |
101 | |
71 | |
61 |