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

     

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