Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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%
I have attached PBI file also
https://drive.google.com/drive/trash
Solved! Go to Solution.
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
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 @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
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 @Anonymous 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
User | Count |
---|---|
123 | |
69 | |
67 | |
58 | |
52 |
User | Count |
---|---|
183 | |
92 | |
67 | |
62 | |
52 |