Forum Discussion
Disconnected Table for Slicing Measures
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 t...
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.