Forum Discussion
Disabling text field aggregation in matrix
Hey Everyone, I have a dashboard using a matrix visualization to summarize some data. Some of the columns are text. The text columns are aggregated (first, last, count or count distinct) and I can't...
Anonymous , isinscope can help for level
example blank for a level and for blank value of another level
if(isinscope(Table[ID]) || isblank(max(Table[ID2])), blank(), [measure])
https://www.kasperonbi.com/use-isinscope-to-get-the-right-hierarchy-level-in-dax/
Hey amitchandak ,
Thank you for your reply. What is the "measure" you are using the the formula? I tried the following formula but is not working and it just returns blank for everything:
Measure = if(isinscope('Sign Billable Transactions'[end_user_id]) || isblank(max('Sign Billable Transactions'[echosignid])),BLANK(),"0")
Both the ID fields are text fields and and one "ID" can have multiple "ID 2"