Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

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...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    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's avatar
    Anonymous
    4 years ago

    Anonymous Awsome!! that did it : ) thanks a bunch Buddy

    /Måns

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

Anonymous ,The information you have provided is not making the problem clear to me. Can you please explain with an example.

Appreciate your Kudos.