Forum Discussion

AO1's avatar
AO1
Frequent Visitor
2 years ago
Solved

New Column or Measure

Hi,   I'm new to PowerBi and would really appreciate your help with creating either a new column or new measure. So i have the below table:   Parameter Treatment Score A TRT1 10 A C...
Dataflows
Need Help
  • wdx223_Daniel's avatar
    wdx223_Daniel
    2 years ago

    DAX:

    CalculatedColumn=MAXX(FILTER(Table,Table[Parameter]=EARLIER(Table[Parameter])&&Table[Treatment]="CON"),Table[Score])

    Measure=CALCULATE(MAX(Table[Score]),ALLEXCEPT(Table,Table[Parameter]=MAX(Table[Parameter]),Table[Treatment]="CON")

     

wdx223_Daniel's avatar
wdx223_Daniel
Community Champion
2 years ago

DAX:

CalculatedColumn=MAXX(FILTER(Table,Table[Parameter]=EARLIER(Table[Parameter])&&Table[Treatment]="CON"),Table[Score])

Measure=CALCULATE(MAX(Table[Score]),ALLEXCEPT(Table,Table[Parameter]=MAX(Table[Parameter]),Table[Treatment]="CON")

 

AO1's avatar
AO1
Frequent Visitor
2 years ago

wdx223_Daniel, your CalculatedColumn formula works flawlessly, and i've used it in different projects. Thank you.

I could not get the Measure formula to work however. I'm currently in need of a measure rather than a calculated column.Yes, the formula is missing a closing bracket, the addition of this bracket did not make it work. I will appreciate if you have a solution for me. Thanks.

  • wdx223_Daniel's avatar
    wdx223_Daniel
    Community Champion
    2 years ago

    Measure=CALCULATE(MAX(Table[Score]),Table[Parameter]=MAX(Table[Parameter]),Table[Treatment]="CON")

    • AO1's avatar
      AO1
      Frequent Visitor
      2 years ago

      Now, it works. Thanks!