Forum Discussion

klehar's avatar
klehar
Helper V
4 years ago
Solved

Conditional calculation based on filter value selected

Hi,    Hi,   I have 4 tables in my dataset (stripping the dataset for simplicity)   Orders Fact Table : Lease and Order Value are my desired output columns in power bi) Fiscal Quarter Geo ...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi klehar ,

     

    I suggest you to create calculated column instead.

    Please check the below formulas.

    C_Capital Lease = LOOKUPVALUE(Inputs[Capital Lease],Inputs[Geo],Orders[Geo])
    C_Order Value = Orders[Amount]*Orders[C_Capital Lease]

    Result:

     

    Best Regards,

    Jay

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi klehar ,

 

I suggest you to create calculated column instead.

Please check the below formulas.

C_Capital Lease = LOOKUPVALUE(Inputs[Capital Lease],Inputs[Geo],Orders[Geo])
C_Order Value = Orders[Amount]*Orders[C_Capital Lease]

Result:

 

Best Regards,

Jay