Forum Discussion
rodfernandez
Helper I
Helper IHow to use Filter selection as a VAR in DAX
Hello, I have the following table Id Month Zone condition 1 1 South Open 2 1 North Open 3 1 North Close 4 2 South Open 5...
rodfernandez solution is attached, you can change it as per your need.
parry2k
Super User
Super Userrodfernandez solution is attached, you can change it as per your need.
rodfernandezHelper I
Helper IOne little question, what would have change in this measure
Number of Open Events = CALCULATE( [Number of Events]; Table1[condition] = "Open" )
if in the condition column instead of having 2 possible states ("Open" and "Close") you would have 4 possible states ("Open", "Close", "In Maintenance" and “ReOpen” ) and you want to display all the ones that are "Open" and "In Maintenance".
Thanks!