Forum Discussion

sdavis's avatar
sdavis
Frequent Visitor
8 years ago
Solved

Divide with a filtered measure

Hi,    I am new to PowerBI and trying to a measured columns in PowerBI for displaying a Card. I'm trying to divide with a filter, but getting an error (screenshot below). How can I devide with a fi...
  • Ashish_Mathur's avatar
    Ashish_Mathur
    8 years ago

    Hi,

     

    Does this work?

     

    =DIVIDE(CALCULATE(COUNT('Sheet1 (2)'[Ticket ID]),FILTER(Sheet1 (2), 'Sheet1 (2)'[First response (hrs)] < 25)),COUNT('Sheet1 (2)'[Ticket ID]))

sdavis's avatar
sdavis
Frequent Visitor
8 years ago

Thank you Ashish_Mathur that worked. 

 

Is there a way I can show the percentage as well? 

Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
8 years ago

Hi,

 

Just format the measure as a % age.

  • sdavis's avatar
    sdavis
    Frequent Visitor
    8 years ago

    Ashish_Mathur I thought of another use case for the formula. Is there a way we can filter out the blank values to make responses under 25 hours and over 0.01 hours? I tried to filter between 25 hours and 0, but it didn't filter the blank values out. 

     

    Here's the formula:

    Tickets Responded (24hrs) = CALCULATE(COUNT('Week'[Ticket ID]), FILTER('Week', 'Week'[First response (hrs)] < 25 && 'Week'[First response (hrs)] >= 0.01))