cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
New Member

Get Row category value next to all sub-category values.

Hello, I was wondering if anyone could help me, I've tried many different things and can't get it to work in my favor.

 

In simple terms: I want to create a new column that that gives me the total category value next  all subtotals value.

209B2B87-2C29-41F0-A9C8-257F8394EA3D.jpeg

  Above is a dumby chart with the calculations I have already done, as it is now: it's just pulls same data over(not how I want it).

(Total should be Vegetable Total+Fruit Total, please ignore the 268 and 828)

 

thank you for any suggestions!

3 REPLIES 3
Community Support
Community Support

Hi, @Itsjandro 

 

You may try creating a calculated column as below.

Column =
CALCULATE (
    SUM ( Table[values] ),
    FILTER (
        ALL ( Table ),
        Table[category] = EARLIER ( Table[category] )
            && Table[Quarter] = EARLIER ( Table[Quarter] )
    )
)

 

Best Regards

Allan

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Super User IV
Super User IV

@Itsjandro , Try a formula like

calculate(sum(Table[values]), filter(allselcted(Table), Table[category] =max(table[category]) && Table[Quarter] =max(table[Quarter])))

 

Please provide your feedback comments and advice for new videos
Tutorial Series Dax Vs SQL Direct Query PBI Tips
Appreciate your Kudos.



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

This worked however Is there any way to translate this into a calculated column, I do not want the data to dynamically change with filters, I want to create a Category total for all subtotals in the Data view, any suggestions on how to do it?

Helpful resources

Announcements
secondImage

Happy New Year from Power BI

This is a must watch for a message from Power BI!

December Update

Check it Out!

Click here to read more about the December 2020 Updates!

Community Blog

Check it Out!

Click here to read the latest blog and learn more about contributing to the Power BI blog!

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.

Top Solution Authors
Top Kudoed Authors