Forum Discussion
VictorV
Helper I
Helper ICreate condition measure for column show in Report View
Hi everyone, Currently, on my Report View, I have a table like below. I want to create a measure, that I will use as a filter TRUE/FALSE. The condition will be like: condition 1: If [Code]...
i changed true false to 1 and 0
Measure 2 = if(ISBLANK(max('Table'[Code]))&&ISBLANK([Measure])||not(ISBLANK(max('Table'[Code])))&¬(ISBLANK([Measure])),1,0)it works on my end, you can have a try.
ryan_mayu
Super User
Super Useryou can create a column
Column = if(ISBLANK('Table'[Code]) && ISBLANK('Table'[Amount]) || not(ISBLANK('Table'[Code]))&& not(ISBLANK('Table'[Amount])),TRUE(),FALSE())
or a measure
Measure = if(ISBLANK(sum('Table'[Amount]))&&ISBLANK(sum('Table'[Code])) ||not(ISBLANK(sum('Table'[Code])))&¬(ISBLANK(sum('Table'[Amount]))),TRUE(),FALSE())
VictorVHelper I
Helper IHi, thanks for your replied.
But in my case [Amount] is a measure, and [Code] is a text. Also, it's not on the same table. The table I show you is from the Report View, it come from 2 table. So, my problem here that how I can create measure with those condition for the table in Report View like that.
- ryan_mayu
i think you can do something like below, pls have a try
Measure 2 = if(ISBLANK(max('Table'[Code]))&&ISBLANK([Measure])||not(ISBLANK(max('Table'[Code])))&¬(ISBLANK([Measure])),TRUE(),FALSE())pls see the attachment below