Commission % in Matrix visualisation

Hi Everyone,

I want to do a simple calculation i.e. Calculation of commission % out of the Gross Premium Received.
Which we can get by Dividing the Commission out of GWP.
Same goes for RI Commission/ RI Ceding.

I have calculated the DAX Measure but i am not able to show it in the Matrix Visualization.
After GWP Column i want to have a % Column and after RI Comm i want to have a % Column.

I have attached the Excel file & Power BI File and Picture of the image- the result i want.

Also i want to know how can i set the sequence of calculated columns in matrix visualization as per my requirement.

Awaiting for your response.
Power Bi- Commission %.pbix (34.8 KB)
Sample Data.xlsx (16.8 KB)

1 Like

I just have a question. RI Commission RI Ceding…Does RI stand for Reinsurance Ceding/Commission? If it does< I spent several years in Reinsurance Areas for a major Insurance Company here in Canada

Yes @Keith . RI Stands for Reinsurance. Great to know that you have spent several years in Insurance Sector.

Can you help me with the Power Bi Question?

@jamie.bryan Can you help?

One of the standing practices of the Community Forum is that we do not call out someone by name. This discourages others from participating in the conversation.

First and foremost, the community is a “best effort” kind of support forum. There are no true guarantees or service level agreements (SLA’s) regarding when you might get an answer. You may not get an answer. Don’t get me wrong, the community is an incredibly robust and amazing resource, but if you are having an urgent issue that needs addressing immediately, you need to get actual Microsoft support involved. To do this, open a support ticket here:

Power BI - https://support.powerbi.com
PowerAutomate - https://flow.microsoft.com/support
Power Apps - https://support.powerapps.com

i was just asking the question if that what is stands for.

1 Like