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 example how the data looks like:
This is what I have created so far. I calclulated the Total sum first:
Total = SUM('Tabelle1'[Count])
Then I calculated the share and after that the percentage share:
Share = CALCULATE([Total]; All('Tabelle1'[Cancelled]))
%Share = DIVIDE([Total]; [Share]; 0)
My table in Power BI looks like this and that is working:
But when I want to see the cancellation rate for the particular date, it does not work.
I then had the idea to use ALLSELECT for this instead of ALL. Unfortunately, this didn't help either and I think I'm a bit lost and don't know what I'm doing.
I think it is a very simple question but I need some help 🙂
Big thanks in advance!