Forum Discussion
ISINSCOPE Query
andybamber , is showing headcount target at this level Domain_Table[cc_domain] on Job level 3,4,5 it should show Headcount . Is this what you need ?
See if this document can help : https://www.kasperonbi.com/use-isinscope-to-get-the-right-hierarchy-level-in-dax/
or
Can you share sample data and sample output in table format?
thanks amitchandak you are correct, that is how i need it to work... I looked at that link you gave me and I dont seem to be able to make that work, also tried daxer's suggestion to order from most granular to least and that doesnt work either... ill try and put together a sample file for you to look at...
Andy
You can also read this: https://www.sqlbi.com/articles/distinguishing-hasonevalue-from-isinscope/Thanks Anonymous amitchandak so i realised why it wasnt working, the visual didnt contain the domain or obs levels, that said i was hoping it would be able to work based off selections from the filter slicer.... when i applied to a visual which had domain and obs, it worked as expected when i drill through... but i guess the question is whether you can do a similar thing based off slicer selections?
Thanks
Andy