Forum Discussion
hidenseek9
Post Patron
Post PatronFacing as issue filtering out data
Hello Power BI Community, I have a problem filtering out data and would love to have your support on it. Here is a problem that I have . Below is a table that I created. What this table doe...
Hi,
You can use “IF” function with “AND” function to create a new measure and that can be added to page level filter or report level filter to identify.
Variance NIL = IF(AND(Actual Spent=0,Plan Spent=0),"1","0")
dilumd
Impactful Individual
Impactful IndividualHi,
You can use “IF” function with “AND” function to create a new measure and that can be added to page level filter or report level filter to identify.
Variance NIL = IF(AND(Actual Spent=0,Plan Spent=0),"1","0")
hidenseek9Post Patron
Post Patron
Thank you so much!
Did not think this could be solved with such an easy measure!!
Many thanks,
H