Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hi community,
I have challenge:
I have a matrix with 5 hierarchies: Manufacturer, Signature, Brand, Sub_Brand, Franchise.
That look like this:
And I want to count the rows occupied by each, something like this in a dynamic way:
Or another option is to have the total rows that belong to each manufacturer as a rolling total like this:
It has to be dynamic to the order of the Matrix visual, so if rows change their order, then the numbers should adjust:
Thank you in advance for your help!
Hi @MareRuiz,
Thank you for reaching out to the Microsoft fabric community forum.
Thank you @FBergamaschi, for you insights.
I have recreated your scenario using sample data on my own. Please find the attached PBIX file for your reference.
If you need any assistance, please let us know.
I hope this information is helpful.
Thank you.
Hi @v-saisrao-msft ,
Thank you for trying, however, the solution is not exactly what I'm looking for. I need something a little bit different:
The pink solution is a running total of the lines showing, at Manufacturer level.
The Red one is an enumeration of the lines.
@FBergamaschi I'll try with visual calculations. Can I use them to filter?
this is a prefect example to try for a visual calculation
Use CALCULATE and COUNTROWS together with the EXPAND/COLLAPSE functions
If this helped, please consider giving kudos and mark as a solution
@me in replies or I'll lose your thread
consider voting this Power BI idea
Francesco Bergamaschi
MBA, M.Eng, M.Econ, Professor of BI
Documentation is here
https://learn.microsoft.com/en-us/power-bi/transform-model/desktop-visual-calculations-overview
If this helped, please consider giving kudos and mark as a solution
@mein replies or I'll lose your thread
consider voting this Power BI idea
Francesco Bergamaschi
MBA, M.Eng, M.Econ, Professor of BI
User | Count |
---|---|
25 | |
10 | |
7 | |
6 | |
6 |
User | Count |
---|---|
30 | |
11 | |
11 | |
9 | |
7 |