Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.
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
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.