Forum Discussion

VictorV's avatar
VictorV
Icon for Helper I rankHelper I
2 years ago
Solved

Create 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]...
General Comment
Need Help
Show and Tell
  • ryan_mayu's avatar
    ryan_mayu
    2 years ago

    i changed true false to 1 and 0

     

    Measure 2 = if(ISBLANK(max('Table'[Code]))&&ISBLANK([Measure])||not(ISBLANK(max('Table'[Code])))&&not(ISBLANK([Measure])),1,0)
     
    it works on my end, you can have a try.
     
ryan_mayu's avatar
ryan_mayu
Icon for Super User rankSuper User
2 years ago

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])))&&not(ISBLANK([Measure])),TRUE(),FALSE())
 
pls see the attachment below
VictorV's avatar
VictorV
Icon for Helper I rankHelper I
2 years ago

Can it put it to filter like this a filter only True

 

  • ryan_mayu's avatar
    ryan_mayu
    Icon for Super User rankSuper User
    2 years ago

    i changed true false to 1 and 0

     

    Measure 2 = if(ISBLANK(max('Table'[Code]))&&ISBLANK([Measure])||not(ISBLANK(max('Table'[Code])))&&not(ISBLANK([Measure])),1,0)
     
    it works on my end, you can have a try.