Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
sukram1
Frequent Visitor

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 example how the data looks like:

sukram1_0-1668664953557.png


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:

sukram1_1-1668665406891.png

But when I want to see the cancellation rate for the particular date, it does not work. 

sukram1_2-1668665589759.png

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!

Markus

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

@sukram1 , Try like

 

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

 

or

 

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

View solution in original post

3 REPLIES 3
Rushki
Regular Visitor

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

Rushki_0-1668673604669.png

 

amitchandak
Super User
Super User

@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 Thank you very much! This is exactly what I am looking for! It works perfect!!

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.