Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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('table'[products] = SELECTEDVALUE('table'[products], 1, 0)
I would like to return 1 if for the selected product in slicer and for other products 0
The matrix table is as below:
Product measure
A 1
B 0
C 0
When applied, I get error msg saying multiple values supplied.
Pls help.
Solved! Go to Solution.
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] )
)
)
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
Thank u sir. It works !!!
In continuation to that, suppose if I want to get a value, say, a column in the product table containing sale amount instead of 1 or 0.....how to achieve this? Would appreciate very much for your help. Thanks
Hi,
Thank you for your feedback.
Please share your sample pbix file's link here, and then I can try to look into it to come with a more accurate solution.
Thank you.
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
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] )
)
)
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
104 | |
101 | |
79 | |
72 | |
64 |
User | Count |
---|---|
142 | |
108 | |
101 | |
81 | |
74 |