Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.
Hi
I have a retail dashboard, where I analyse sales performance by band. I have 3 formulas that rank all Brands by the store (based on the type of product sold).
- Niche Rank (Ranks all sales from 'Niche' products)
RANK(NICHE) = IF (
NOT ( ISBLANK ( [NicheSales(TY)] ) ),
RANKX (
FILTER ( ALL ( 'Niche Dashboard'[FINAL BRAND]), NOT ( ISBLANK ( [NicheSales(TY)] ) ) ),
[NicheSales(TY)]
)
)
- Classic Rank (Ranks all sales from 'Classic' products)
RANK(CLASSIC) = RANKX(ALL('Niche Dashboard'[FINAL BRAND]),[ClassicSales(TY)])
- Overall rank (Ranks total sales)
RANK(OVERALL) = RANKX(ALL('Niche Dashboard'[FINAL BRAND]),[NDAllSales(TY)])
However, I noticed that when all brands are selected, the RANKX fuctions works perfectly, but if I select just 1 brand (see the second picture) the ranks go up by 1 for the selected brand. I have no idea what the issue is.
UNFILTERED
FILTERED
Check out the November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.