DAX Calculation - % by dividing 2 columns. Please HELP!

[JayKarim]

Hello Power BI Community, 

I'm trying to work out a % calulation based on apply to conditions to 2 columns e.g.

Field type: Number %.   A % of the total number of claims which are marked as No in 'Review Column' against the total number of claims marked as 'open' in 'status' column

Please help me to calculate this as a % 

Many thanks in advance 🙂

Jay

[v-kkf-msft · Accepted solution]

Hi @JayKarim ,

Please try the measure.

Measure = 
DIVIDE (
    CALCULATE ( SUM ( 'Table'[claims] ), 'Table'[Review Column] = "No" ),
    CALCULATE ( SUM ( 'Table'[claims] ), 'Table'[status] = "open" )
)

If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
Best Regards,
Winniz
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Kishore_Kadhir]

Hi @JayKarim 

Please provide some sample data and show us the expected result.

Regards,

Kishore

[JayKarim]

Hi Kishore, 

I don't think there will be any need for sample data.

i'm after a formula for the following:

% of the total number of claims which are marked as No in 'Review Column' against the total number of claims marked as 'open' in 'status' column

Thanks,

Jay