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

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
GVTioluxe
Helper I
Helper I

Calculation Groups in Matrix Visual presentation

I have following information of inventory  that needs to be presented in a Matrix visual as shown below (some are fields from table, some are measures ) - 

Brand - field value from a Item table from  Item table which is connected to Stock Table by Item ID

Sub Brand - field value from Item table from  Item table which is connected to Stock Table by Item ID

item - field value from  Item table which is connected to Stock Table by Item ID

stock qty - measure from stock table

listed sale price - measure from Price List Table where the Listed Sale price is stored

cost price - measure from Stock Table

margin - measures (calculated from Listed Sale Price and cost Price)

Stock  received date -  show the date hierarchy from Calendar Table which is connected to Stock Table by Received Date as the key

expected Matrix visual  - present these under timeline of stock received date

                                                                                                           2023

                                                                                                           Jan23    Feb23    Mar23    Apr23

Brand  Sub brand   Item  Cost Price  Listed Sale Price  Margin%      stk qty   stk qty   stk qty   stk qty  

 

There was a solution using calcultion groups  in following youtube video which i tried by creating a calculation group with calculation items for each of the measure with the IF(NOT(ISINSCOPE)) as used in the video, but when i bring it into the matrix visual as suggested and drill down by column, under each timeline it repeats the measure value instead of showing as a single column as shown in the video.

 

can anyone help?

 

 

 

 

 

 

 

 

2 REPLIES 2
v-shex-msft
Community Support
Community Support

Hi @GVTioluxe,

I'd like to suggest you take a look at the following blog about introducing and usage of calculation groups if it helps with your scenario:

Introducing Calculation Groups - SQLBI

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

I haev gone through this tutorial as well as the one i had shared but the answer is not there

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

Jan NL Carousel

Fabric Community Update - January 2025

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