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 All
I'm trying to slice a Measure but using the disconnected table method. This formula is working providing there is a selection. When there is no selection, my visual is blank. I need it to show all if there's no selection. Is there a tweak to the formula or a different method that will deliver the desired outcome?
New Measure = IF('Combined_Tbl (2)'[Status Number]=SELECTEDVALUE('Value Selection'[Status No]),1,0)
Many thanks!
This minor change may work as well:
New Measure = IF('Combined_Tbl (2)'[Status Number]=SELECTEDVALUE('Value Selection'[Status No],1),1,0)
The SELECTEDVALUE function has a second optional argument that allows you to define which value should be returned when more than one value is selected.
Try Like
New Measure = if(isfiltered('Combined_Tbl (2)'[Status Number])
,IF('Combined_Tbl (2)'[Status Number]=SELECTEDVALUE('Value Selection'[Status No]),1,0)
0)
Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution.
In case it does not help, please provide additional information and mark me with @
Thanks. My Recent Blogs -Decoding Direct Query - Time Intelligence, Winner Coloring on MAP, HR Analytics, Power BI Working with Non-Standard TimeAnd Comparing Data Across Date Ranges
Connect on Linkedin
Many thanks for the suggestions. I tried your isfiltered solution @amitchandak but I think it didn't work due to [Status Number] being a measure. I solved my issue in the end using SWITCH.
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 |
---|---|
113 | |
97 | |
79 | |
73 | |
56 |
User | Count |
---|---|
145 | |
105 | |
104 | |
90 | |
63 |