Calculate - logical text

Question

I have measure B&nbsp;Measure B =Calculate ( Sum( Table[column1]); Table[column2]= measure A.).It shows error ,because Logital test is not allowed in calculate&nbsp;&nbsp;

v-yulgu-msft · Answer

Hi&nbsp;pstanek,&nbsp;Please modify the formula as:Measure B =Calculate ( Sum( Table[column1]), FILTER(Table,Table[column2]= [Measure A]))Thanks,Yuliana Gu

pstanek · Answer

It doesn´t work tooTable[column2]= [Measure A]Is logilal test ,so IT gives the same mistake.&nbsp;

baskar · Answer

Can u explain bit about your Measure A.&nbsp;Bec for me it is working fine .&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;

pstanek · Answer

IT is date , not number. Measure=MAX[date].&nbsp; Maybe it si because&nbsp; of direct query

baskar · Answer

okay Cool.&nbsp;do one this, get the Measure in var. like&nbsp;Measure B =Var Meas_A = measure A&nbsp;Return&nbsp;Calculate ( Sum( Table[column1]); Table[column2]= Meas_A)&nbsp;Try this.&nbsp;&nbsp;For this Direct Quesry is not a prob am sure.&nbsp;let me know what happen&nbsp;

Forum Discussion

Calculate - logical text

5 Replies

Related content

Logic problem?

Commitment value calculating incorrectly - DAX Logic

Dax logic for Amortization Calculation

Write logic for Calculated Column or Measure

FX Conversion Logic