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.
Hello guys,
I have made one table as as SlicerTable to define the number for each measure:
And then I created these measures for the visual:
Solved! Go to Solution.
Hello @v-jayw-msft and @Jihwan_Kim, thank you very much for your suggestions. But I solved this problem already.
My measure now looks like this and this works with multiple selection too:
Hi @Clout ,
You will find the value of "ISBLANK(SELECTEDVALUE(SlicerTable[Slicer Value]))" would be true if you select more than one value in the slicer. You could use "NOT(ISFILTERED('SlicerTable'[Selected Measure]))" instead.
Best Regards,
Jay
Hello @v-jayw-msft and @Jihwan_Kim, thank you very much for your suggestions. But I solved this problem already.
My measure now looks like this and this works with multiple selection too:
Hi, @Clout
Please correct me if I wrongly understood your question.
Instead of using selectedvalue, please try to use ALLSELECTED together with IN function.
If it is OK with you, please share sample pbix file's link after deleting important data, then I can try to look into it to come up with a more accurate measure.
Thank you.
Hi, My name is Jihwan Kim.
If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.
Linkedin: https://www.linkedin.com/in/jihwankim1975/
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 |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |