Forum Discussion
Custom filter for a calculated measure
Hi all. I have a custom measure which obtains a value via LOOKUPVALUE. It basically compares values in a column is table A with those in table be. When it finds a match (a string) it returns the val...
But how? I don't seem to be able to bring over columns from those 2 tables (say, Table A and B) into a new table.
I can create a table alright, but I can only bring in columns from one of those tables (I tried vie SUMMARIZE()).
For clarification, Table A is in DirectQuery mode, and Table B is in import mode - i'm not sure whethter that has anything to do with the issue I'm facing?
TO create a new table was the first thing that came to mind but it's simply not working for me...
ERD
Community Champion
Community ChampionPlease, provide some demo. Use this for reference: https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-Get-Your-Question-Answered-Quickly/m-p/1626726#M32906