Forum Discussion

Thulasiraman's avatar
Thulasiraman
Helper II
4 years ago
Solved

Dax Error-Multiple value selected

Hi I am new to power bi and I have an issue with a dax query. I have a table containing names of products. I have created a slicer of the products column I have created a dax query - IF(VALUES('t...
Need Help
  • Jihwan_Kim's avatar
    Jihwan_Kim
    4 years ago

    Hi,

    Please check the below picture and the attached pbix file.

    One of ways to create a visualization as you needed is to have disconnected slicer table like below.

     

     

    Desired outcome measure: =
IF (
    HASONEVALUE ( 'Product'[Product] ),
    INT (
        SELECTEDVALUE ( 'Product'[Product] ) IN VALUES ( 'Slicer table'[Product] )
    )
)
Jihwan_Kim's avatar
Jihwan_Kim
Super User
4 years ago

Hi,

Please check the below picture and the attached pbix file.

One of ways to create a visualization as you needed is to have disconnected slicer table like below.

 

 

Desired outcome measure: =
IF (
    HASONEVALUE ( 'Product'[Product] ),
    INT (
        SELECTEDVALUE ( 'Product'[Product] ) IN VALUES ( 'Slicer table'[Product] )
    )
)