Risk Completion % using grand total - How to write the DAX pls?

[byWing]

Hi All,

I have this table, which I am trying to create:

Risk Completion % by FiscalQuarter = [Reduction Completion]/ Grand total of [Reduction Opportunity] x 100%

Both [Reduction Completion] and [Reduction Opportunity] are measures.

I have tried but I just don't understand how to craft the DAX pls.

Appreciate your help pls. 

Thank you.

[Anonymous]

Hi, @byWing 

You can try the following methods.

Measure = 
Var _Sumall=SUMX(ALL('Table'),[Reduction Opportunity])
RETURN
DIVIDE([Reduction Completion],_Sumall)

Is this the result you expected?

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Jihwan_Kim · Accepted solution]

Hi,

I am not sure how your semantic model looks like, but I tried to create a sample pbix file like below.

Please check the below picture and the attached pbix file.

Risk completion %: = 
DIVIDE (
    [Reduction completion:],
    CALCULATE ( [Reduction Opportunity:], ALLSELECTED ( 'calendar'[Year Quarter] ) )
)

[byWing]

Thank you for your reply. I tried it and it worked. 😃