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

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
PowerBI_User23
Frequent Visitor

Need Help in calculating percentage at total level in matrix

Hi All,

 

Could you please help me to calculate percantage at total level .

 

For example in below sceriao  at total level its showing 217 %  but its should be Total GP/Price %(45/210%)=21%

 

 

 

PowerBI_User23_1-1686659896126.png

 

 I have attached PBI file also 

https://drive.google.com/drive/trash 

 

1 ACCEPTED SOLUTION
v-binbinyu-msft
Community Support
Community Support

Hi @PowerBI_User23 ,

Please try below steps:

1. create a measure with below dax formula

Gp Percentage =
VAR _gp =
    SELECTEDVALUE ( 'Table'[GP] )
VAR _price =
    SELECTEDVALUE ( 'Table'[Price] )
VAR sum_price =
    SUMX ( ALL ( 'Table' ), [Price] )
VAR sum_gp =
    SUMX ( ALL ( 'Table' ), [GP] )
RETURN
    IF (
        ISFILTERED ( 'Table' ),
        DIVIDE ( _gp, _price ),
        DIVIDE ( sum_gp, sum_price )
    )

2. add a matrix visual with table fields and measure

vbinbinyumsft_0-1686794650183.png

Please refer the attached .pbix file.

 

Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

2 REPLIES 2
v-binbinyu-msft
Community Support
Community Support

Hi @PowerBI_User23 ,

Please try below steps:

1. create a measure with below dax formula

Gp Percentage =
VAR _gp =
    SELECTEDVALUE ( 'Table'[GP] )
VAR _price =
    SELECTEDVALUE ( 'Table'[Price] )
VAR sum_price =
    SUMX ( ALL ( 'Table' ), [Price] )
VAR sum_gp =
    SUMX ( ALL ( 'Table' ), [GP] )
RETURN
    IF (
        ISFILTERED ( 'Table' ),
        DIVIDE ( _gp, _price ),
        DIVIDE ( sum_gp, sum_price )
    )

2. add a matrix visual with table fields and measure

vbinbinyumsft_0-1686794650183.png

Please refer the attached .pbix file.

 

Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Hi @v-binbinyu-msft   Thankyou for reply its working if there only one dimension what if i have multiple hirechy for example in below condition :

I am unable to get the at subtotal level , do i need to apply group by kind of thing , please once check this scenrio also and let me know if get the solution for this .

 

Attaching PBI file https://drive.google.com/drive/my-drive 

 

PowerBI_User23_0-1686821709513.png

 

 

 

 

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.