Forum Discussion
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...
I have exactly the same but Year, Month and Day are text type:
Columns which i grouping are: Year, Month, Day.
Value column is: Value
Table with Year,Month,Day nad Value is Table_Name.
Maybe I make some wrong with name of columns or table. I dont know 😞
But if you do this, doesn't it work?
sumSc = SWITCH(
TRUE(),
ISINSCOPE('Table'[Day]),SUM('Table'[IndeksVisible]),
""
)
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
no value 😞
It is a measure, not a calculated column
I have exactly the same but Year, Month and Day are text type:
