Forum Discussion

derekli17001's avatar
derekli17001
Icon for Helper I rankHelper I
2 years ago
Solved

How 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...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    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.

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi, derekli17001 

You may want to consider using Bookmark, as follows:

Create a bookmark and bind it to a Button. Create two tables on the original page, one with count and one with Yes or No. Use Bookmark to record the status of All and hide another table.

 

 

To return to the status of selecting a customer, click another Button.

 

 

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.

 

  • derekli17001's avatar
    derekli17001
    Icon for Helper I rankHelper I
    2 years ago

    Is there a fomula/conditional column option rather than using bookmarks?

    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

      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.