Forum Discussion

EDS's avatar
EDS
Icon for Helper I rankHelper I
3 years ago
Solved

FORMUAL DAX

Buenos días, soy nuevo en Power bi y tengo una duda. Es referente a tarifas de clientes. Tengo una tabla de clientes, en la primera columna el codigo de cliente en la siguiente columna la tarifa cl...
  • v-xiaotang's avatar
    v-xiaotang
    3 years ago

    Hi EDS 

    Thanks for reaching out to us.

    please try this measure,

    Measure = 
var _product="A"
var _value= CALCULATE(MAX(Table2[TARIFA]),FILTER(Table2,Table2[TARIFAS]=MIN(Table1[CLIENTE]) && Table2[PRODUCTO]=_product))
return IF(ISBLANK(MIN(Table1[TARIFA CLIENTE])),_value,MIN(Table1[TARIFA CLIENTE]))

     

    Best Regards,

    Community Support Team _Tang

    If this post helps, please consider Accept it as the solution to help the other members find it more quickly.

v-xiaotang's avatar
v-xiaotang
Icon for Community Support rankCommunity Support
3 years ago

Hi EDS 

Thanks for reaching out to us.

please try this measure,

Measure = 
var _product="A"
var _value= CALCULATE(MAX(Table2[TARIFA]),FILTER(Table2,Table2[TARIFAS]=MIN(Table1[CLIENTE]) && Table2[PRODUCTO]=_product))
return IF(ISBLANK(MIN(Table1[TARIFA CLIENTE])),_value,MIN(Table1[TARIFA CLIENTE]))

 

Best Regards,

Community Support Team _Tang

If this post helps, please consider Accept it as the solution to help the other members find it more quickly.