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,
I am not clear. Share yoru dataset and show the expected result.
Are you able to download my .pbix file from the link?
- Ashish_Mathur
Hi,
Just filter the measure int he visual filter section (look at the visualisation pane).
Hope this helps.
Is there a way I can just filter a measure shown on a card without the entire page?
My new link shows an example with other charts included: https://www.dropbox.com/s/3uoxzx93srmowmd/Example_help.pbix?dl=0