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

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

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
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

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

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.