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

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hey sukram1 
Please find below the base data, the measure and the two outputs (by Cancellation Status and by Date)
Please like If you find this helpful. The measure is quite simple. It will work automatically with the Yes/No status and Dates