Forum Discussion
Blanks wanted
Hi All I´m trying to get measure below to only show values for columns Uppgift and År Månad(from date table). Budgeterad kostnad = SUMX ( 'Fördelningsnyckel', VAR __h = CALCULATE ( SUM('F...
Hi Anonymous ，
You could use ISINSCOPE() or ISFILTER() function.
For example:
Measure = IF(ISINSCOPE('Table'[Namn]),BLANK(),[Budgeterad kostnad])Result would be shown like below.Best Regards,JayAnonymous Awsome!! that did it : ) thanks a bunch Buddy
/Måns
Hi Anonymous ，
You could use ISINSCOPE() or ISFILTER() function.
For example:
Measure = IF(ISINSCOPE('Table'[Namn]),BLANK(),[Budgeterad kostnad])
Result would be shown like below.
Best Regards,
Jay
Anonymous Awsome!! that did it : ) thanks a bunch Buddy
/Måns