Forum Discussion

byWing's avatar
byWing
Icon for Helper I rankHelper I
2 years ago
Solved

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

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 Completio...
Need Help
  • Jihwan_Kim's avatar
    Jihwan_Kim
    2 years ago

    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] ) )
)

     

Jihwan_Kim's avatar
Jihwan_Kim
Icon for Super User rankSuper User
2 years ago

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's avatar
byWing
Icon for Helper I rankHelper I
2 years ago

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