Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hello -
How do I do this? I cannot figure it out. I need a running total down a column by parent categories. They need to build on one another. Category 1 is worst case. Category 2 is better case (results from 1+2) and Category 3 is even better case (1+2+3).
Example below:
hi, @Anonymous
After my reseach, you could try this way as below:
Step1:
Create a Dim Level table for category like this:
Step2:
Create a relationship like this:
Step3:
create a measure by this formula
Measure = CALCULATE(SUM(Table1[Value]),FILTER(ALL('Dim Level'),'Dim Level'[Level]<=MAX('Dim Level'[Level])))
Drag category field from dim level table and set Format->Values->show on rows
Result:
Best Regards,
Lin
Hello -
Thank you for getting back to me. Unfortunately, I tried this but it did not give me the resulet I needed. I do not see any subcategories?
Here is another example below - animal total is added to reptile total is added to bird total.
hi, @Anonymous
You could try this way:
Step1:
Create a Dim Level table for Category like this:
Note: you could use Sort by column in Power BI Desktop for the sort in visual
(select Category field then click Modeling->Sort by Column->Level)
https://docs.microsoft.com/en-us/power-bi/desktop-sort-by-column
Step2:
Use this formula to add a measure
Measure = CALCULATE(SUM(Table1[Weight]),FILTER(ALL('Dim Level'),'Dim Level'[Level]<=MAX('Dim Level'[Level])))
Step3:
Add a matrix visual like this
Step4:
Drag Weight filed into visual level filter and setWeight is not blank.
Result:
Best Regards,
Lin
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
118 | |
101 | |
71 | |
61 |