Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
Oggie
Frequent Visitor

Nesting of Calculation groups or Calculation Group items with measures

Hi! I desperately need your help with calculation groups... I am trying to get to the following result with nested calculation groups but am stuck... 
Oggie_2-1731254504172.png
I have created two calculation groups that gives me the correct values as follows in a Matrix:

Oggie_1-1731254280643.png

I now want to nest the Rows into the columns to be able to show products on rows instead, like the picture above. How should I resolve that?

 

The rows are parts of a calculation groups with links to measures with the following code:

Revenue (Local Curr) = CALCULATE(sum(fact_ledger_entry[amount]),dim_internal_statement_row[level1_id]="300"
Volumes (# Sold tires) = CALCULATE(sum(fact_ledger_entry[quantity]), dim_internal_statement_row[level1_id]="300")
 
The columns are also part of a calculation group but with the code written directly in the calculation item as follows:

MTD Act = CALCULATE( TOTALMTD( SELECTEDMEASURE(), dim_fiscal_calendar[ledger_date]), fact_ledger_entry[ledger_kind] = "ActualBilling", fact_ledger_entry[source.fiscal_period_index] <> 0 )

MTD Act PY = CALCULATE( TOTALMTD (selectedmeasure(), sameperiodlastyear(dim_fiscal_calendar[ledger_date])) ,fact_ledger_entry[ledger_kind]="ActualBilling")

I am using the following measure as "VAlues" in the matrix 
AmountSum = sum(fact_ledger_entry[amount])

Hope you can help!! 
All the best

 

 

1 REPLY 1
parry2k
Super User
Super User

@Oggie what is the precedence? check this video on my YT channel:

 

Learn how precedence setting in calculation groups help in interaction between visuals - Power BI

 

 



Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤


Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors