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]),
    ""
)

 

Momo2020's avatar
Momo2020
Frequent Visitor
2 years ago

Dear mlsx4,

thank you for your suggestion of ISINSCOPE function. I was struggling with HASONEVALUE in case where there was only one value in one group, while I wanted to show the value only on total rows. You saved my mind!

Best regards,

Monika