Forum Discussion
derekli17001
Helper I
Helper IHow to make a table count values until slicer is selected
This is my excel sheet On my dashboard- i have 3 customers and the same items with varying conditions of either yes or no. I want it so that when no slicers for specific customers (column c) a...
Hi, derekli17001
Try the following DAX:
Measure = IF(ISFILTERED('Table'[Customer]), SELECTEDVALUE('Table'[INCLUDE]), COUNT('Table'[INCLUDE]) )In the case that no customer is selected
While choosing a customer to slice
How to Get Your Question Answered Quickly
Best Regards
Yongkang Hua
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
derekli17001Helper I
Helper IIs there a fomula/conditional column option rather than using bookmarks?
Hi, derekli17001
Try the following DAX:
Measure =
IF(ISFILTERED('Table'[Customer]),
SELECTEDVALUE('Table'[INCLUDE]),
COUNT('Table'[INCLUDE])
)In the case that no customer is selected
While choosing a customer to slice
How to Get Your Question Answered Quickly
Best Regards
Yongkang Hua
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.