need help on the measure

[yanzhao_LBS]

i have made a matrix, the above is the detail and the last part is the summary,

Legacy_Qty_PY & Measure2 is the measure i created.and i want to create another measure to calculate the measure 2 value which the Legacy_Qty_py larger than 1.

 and i create a Measure 20

Measure20 = CALCULATE([Measure 2],FILTER('CHN Bowler Database',[Legacy_Qty_PY]>1))

but no value displayed.

please help about the measure,thanks

[Thennarasu_R]

Hi @yanzhao_LBS 

Try this calculation ,I hope this one help to you If not get exact answer let me known.

Measure=IF (CALCULATE('CHN Bowler Database',[Legacy_Qty_PY]>1),CALCULATE([Measure 2],BLANK()))
Check this one,

Thanks ,
Thennarasu

[yanzhao_LBS]

Thanks for your reply ,but it seems not work

[Thennarasu_R · Accepted solution]

@yanzhao_LBS 
Sorry,
Small Syntax Correction , you need to remove table name after Calculate Function.

Measure=IF (CALCULATE([Legacy_Qty_PY]>1),CALCULATE([Measure 2],BLANK()))

try this ,

Thanks ,
Thennarasu

[yanzhao_LBS]

i think the calculation is by the summary,but i want is by detail. do you know how to by detail?

[yanzhao_LBS]

seems work , thanks for your help . i will check it deeper and accept this.