Forum Discussion
Slicer to filter data
That i believe is impossible. What you could do is create a slicer with just the option "Yes" and name it show vendor only or something.
When yes is not selected it will show all the Yes and no's.
You Can create value tables. And based on then you can change the filter in your measure.
One way change the filter based on the value another change measure that has a different filter
Measure =
var _sel = max(newTable[value])
var _me1 = calculate(sum(sale[amount]),sale[type]="Show room")
var _me2 = calculate(sum(sale[amount]))
return
if (_sel ="NO", [_me2], [_me1]
)
Change as per table and column name
Also refer
Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks. My Recent Blog -
Winner-Topper-on-Map-How-to-Color-States-on-a-Map-with-Winners , HR-Analytics-Active-Employee-Hire-and-Termination-trend
Power-BI-Working-with-Non-Standard-Time-Periods And Comparing-Data-Across-Date-Ranges
Connect on Linkedin