Forum Discussion

bjurek's avatar
bjurek
Helper I
3 years ago
Solved

HASONEVALUE problem

in the Power BI Dekstop program, I have 4 columns that I place in the matrix visualization. I put Year column, Month column and Day column in rows and Value column in values. Would like to not show...
Need Help
  • mlsx4's avatar
    mlsx4
    3 years ago

    I have exactly the same but Year, Month and Day are text type:

     

     

mlsx4's avatar
mlsx4
Memorable Member
3 years ago

But if you do this, doesn't it work?

sumSc = SWITCH(
    TRUE(),
    ISINSCOPE('Table'[Day]),SUM('Table'[IndeksVisible]),
    ""
)

 

bjurek's avatar
bjurek
Helper I
3 years ago

no value 😞 

 

  • mlsx4's avatar
    mlsx4
    Memorable Member
    3 years ago

    It is a measure, not a calculated column

  • bjurek's avatar
    bjurek
    Helper I
    3 years ago

     

  • mlsx4's avatar
    mlsx4
    Memorable Member
    3 years ago

    I have exactly the same but Year, Month and Day are text type: