Forum Discussion
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...
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]))
Ashish_Mathur
Super User
Super UserHi,
How can tht division yield the result as 6? The number of records with a response time as < 25 hours is 4. 4/10 should be 40%.
Ashish_Mathur thank you for catching that, I edited the post. It should be 40%.
- Ashish_Mathur
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]))
- Ashish_Mathur
Hi,
Just format the measure as a % age.
Thank you sooooo much for this. Gahhh, I was struggling.
- Ashish_Mathur
You are welcome.
