Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

slicer no selection

Hello, being new in power BI, I have a lot of beginner questions!   I want to count and display the disctint values of a specific column, for that I created a measure using DISTINCTCOUNT function. ...
Need Help
  • v-danhe-msft's avatar
    v-danhe-msft
    7 years ago

    Hi Anonymous,

    I have modified my formula with countProd, you could refer to it:

    countProd = IF(ISFILTERED(Sheet7[Product]),DISTINCTCOUNT(Sheet7[Product]),IF(ISBLANK(SELECTEDVALUE(Sheet7[Product])),0))

    Result:

    Hope it could help you.

     

    Regards,

    Daniel He

     

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi v-danhe-msft 

 

I manage to open your power bi file, and it results that the difference between your solution and mine is that I need that the user can select ONE or multiple answers (countries in my case or products in the case you reproduce). so when I change the slicer into off "single select" then I still don't get the counts that I want using either the first count or the second one. WHen nothing is selected there is always the total number that appears and not 0. 

 

I would like to have an IF condition about if nothing is selected but apparently isblank(isselected()) is not the right one, cause isselected works for a single selection.

 

Thanks for your further help!

v-danhe-msft's avatar
v-danhe-msft
Icon for Microsoft Employee rankMicrosoft Employee
7 years ago

Hi Anonymous,

I have modified my formula with countProd, you could refer to it:

countProd = IF(ISFILTERED(Sheet7[Product]),DISTINCTCOUNT(Sheet7[Product]),IF(ISBLANK(SELECTEDVALUE(Sheet7[Product])),0))

Result:

Hope it could help you.

 

Regards,

Daniel He

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    It works thanks a lot!

     

    Would you tell me which power bi version do you have?

    Because your pbix file can't be opened using my version,

     

    Thanks again!

    Regards,

    • v-danhe-msft's avatar
      v-danhe-msft
      Icon for Microsoft Employee rankMicrosoft Employee
      7 years ago

      Hi Anonymous,

      Here is my version: 2.62.5222.601 64-bit (September 2018)

      Hope it could help you.

       

      Regards,

      Daniel He