DAX - Add column referring to a measure.

[Diego_Vialle]

Hello, I need to add the values that are marked in the column to the side. The column "New Bimonthly Customers" derives from a measure created:

Novos Clientes Bimestrais =

VAR AllOldCustomers =

CALCULATETABLE (

VALUES ( SBOPRODMS[Nome do PN] ),

SBOPRODMS,

SBOPRODMS[Data NF]

< TODAY () - 60,

SBOPRODMS[Documento] = "Nota fiscal de saída"

)

VAR AllNewCustomers =

CALCULATETABLE (

VALUES ( SBOPRODMS[Nome do PN] ),

SBOPRODMS[Data NF]

< TODAY () ,

SBOPRODMS[Documento] = "Nota fiscal de saída"

)

RETURN

COUNTROWS ( EXCEPT ( AllNewCustomers, AllOldCustomers ) )

[tamerj1 · Accepted solution]

Hi Diego 

Not sure if I fully understand but you may try this

Valor Clientes Bimestrais =
SUMX (
    VALUES ( SBOPRODMS[Nome do PN] ),
    IF ( [Novos Clientes Bimestrais] = 1, [Valor NET | NF] )
)

[Diego_Vialle]

Perfect. Is correct !! I will use the same for New Semiannual Customers.

I was wrong when using the Bimonthly New Customers measure within SUMX. It was giving placeholder error.

I have another question, but I'll open it in another message here on the forum. Thank you one more time.

[tamerj1]

Hi @Diego_Vialle 

what do you mean by "add to the side"?

[Diego_Vialle]

Add up according to the clients that are marked as bimonthly. Sorry, I use google translate