Forum Discussion

sukram1's avatar
sukram1
Frequent Visitor
3 years ago
Solved

Break down calculated share to date

Hi! I have been using the basics of Power BI since a few months but I am relatively new to DAX. I have contract data and would like to calculate a cancellation rate for these.   These are an exa...
Need Help
  • amitchandak's avatar
    amitchandak
    3 years ago

    sukram1 , Try like

     

    Divide(CALCULATE([Total]; Filter( 'Tabelle1','Tabelle1'[Cancelled] ="Yes") ),[Total])

     

    or

     

    Divide(CALCULATE([Total]; Filter( 'Tabelle1','Tabelle1'[Cancelled] ="Yes") ),calculate([Total],allselected()) )

amitchandak's avatar
amitchandak
Super User
3 years ago

sukram1 , Try like

 

Divide(CALCULATE([Total]; Filter( 'Tabelle1','Tabelle1'[Cancelled] ="Yes") ),[Total])

 

or

 

Divide(CALCULATE([Total]; Filter( 'Tabelle1','Tabelle1'[Cancelled] ="Yes") ),calculate([Total],allselected()) )

  • sukram1's avatar
    sukram1
    Frequent Visitor
    3 years ago

    amitchandak Thank you very much! This is exactly what I am looking for! It works perfect!!