Forum Discussion

marcio_fornari's avatar
marcio_fornari
Resolver I
5 years ago
Solved

Measure repeating values for table

Hello, I have a table with 2 columns.. Type and Value   Measure 1:  toPay = CALCULATE( SUM(PAYMENTS[value]), PAYMENTS[type] = "pay" )   Measure 2: toReceive = CALCULATE( ...
Need Help
  • amitchandak's avatar
    amitchandak
    5 years ago

    marcio_fornari , Try like

     

    toPay =
    CALCULATE(
    SUM(PAYMENTS[value]),
    filter(PAYMENTS, PAYMENTS[type] = "pay")
    )

     

    toReceive =
    CALCULATE(
    SUM(PAYMENTS[value]),
    filter(PAYMENTS,PAYMENTS[type] = "receive")
    )

     

    refer : dataap.org/blog/2019/04/22/difference-between-calculate-with-and-without-filter-expression/

amitchandak's avatar
amitchandak
Super User
5 years ago

marcio_fornari , Try like

 

toPay =
CALCULATE(
SUM(PAYMENTS[value]),
filter(PAYMENTS, PAYMENTS[type] = "pay")
)

 

toReceive =
CALCULATE(
SUM(PAYMENTS[value]),
filter(PAYMENTS,PAYMENTS[type] = "receive")
)

 

refer : dataap.org/blog/2019/04/22/difference-between-calculate-with-and-without-filter-expression/

marcio_fornari's avatar
marcio_fornari
Resolver I
5 years ago

Thanks amitchandak it's works!!
Thanks for the Refer too 🙂