Forum Discussion

smpa01's avatar
smpa01
Community Champion
5 years ago

ISEMPTY to evaluate only for connected values

Following is my sample data (pbix attached) and data model       I want to bring site and month from keyTbl in a matrix viz and show if there any single row exists in condition tbl...
Need Help
Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi smpa01 ,

 

Maybe you could try using filter instead of Dax like this：

 

If I have not understood your needs correctly, please do not hesitate to inform me.

 

Hope it helps,


Community Support Team _ Caitlyn Yan

smpa01's avatar
smpa01
Community Champion
4 years ago

Hi Kaitlyn,

Thanks for looking into it. unfortunately, this is not the I was looking forward to. My table has 2.5M+ rows and constantly compounding. It is not possible to put a manual harcoded filter there unless I can do this with an explicit measure.

 

Thanks