Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Why new Column & Measure not working properly

Hi All, i have a two table (OINV, Sales), Oinv is Invoice table and sales is multi table joined include OINV also So now Sales table i have to Subtract between two column, when i am trying new cal...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Thank you for solution V-jianpeng, i have used the below measure its worked 


    Bal Amt1 =
    SUMX(
    VALUES('sales 1'[OINV.DocEntry]),
    CALCULATE(
    MAX('sales 1'[OINV.DocTotal])-MAX('sales 1'[OINV.VatSum])
    )
    )

  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi, Anonymous 

    Thank you a lot for sharing the solution. You can mark helpful replies and solutions you share as solutions so that others in the community can quickly find answers to the same problem. Thank you again for your cooperation.

     

     

    Best Regards

    Jianpeng Li

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

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Thank you for solution V-jianpeng, i have used the below measure its worked 


Bal Amt1 =
SUMX(
VALUES('sales 1'[OINV.DocEntry]),
CALCULATE(
MAX('sales 1'[OINV.DocTotal])-MAX('sales 1'[OINV.VatSum])
)
)

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi, Anonymous 

Thank you a lot for sharing the solution. You can mark helpful replies and solutions you share as solutions so that others in the community can quickly find answers to the same problem. Thank you again for your cooperation.

 

 

Best Regards

Jianpeng Li

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