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

The 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.

Reply
AshishSingh-769
Frequent Visitor

Need help in matrix

AshishSingh769_0-1713252528851.png

 I have to datasets Account, and LRData In from Account table I am getting the account Name and from LRData table I am getting IncurredLoss, EarnedPremium and lossRatio. Now I want to show above report in BI. note that in the header row I dont want the sum of LossRatio and want a new column in header LRYTD which will show the sum of IncurredLoss divided by sum of EarnedPremium as percentage for that account. 

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

@AshishSingh-769 , if these are measures you can use isinscope and switch the values

 

How to Switch Subtotal and Grand Total in Power BI | Power BI Tutorials| isinscope: https://youtu.be/smhIPw3OkKA

 

if these are column values, then you switch based on the value

 

Power BI How to get the P&L formatting right: https://youtu.be/C9K8uVfthUU

Full Power BI Video 20 Hours YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

View solution in original post

1 REPLY 1
amitchandak
Super User
Super User

@AshishSingh-769 , if these are measures you can use isinscope and switch the values

 

How to Switch Subtotal and Grand Total in Power BI | Power BI Tutorials| isinscope: https://youtu.be/smhIPw3OkKA

 

if these are column values, then you switch based on the value

 

Power BI How to get the P&L formatting right: https://youtu.be/C9K8uVfthUU

Full Power BI Video 20 Hours YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

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