topic Re: DAX - Add column referring to a measure. in DAX Commands and Tips

DAX - Add column referring to a measure.

Diego_Vialle — Sat, 16 Apr 2022 00:31:34 GMT

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 — Sat, 16 Apr 2022 02:14:23 GMT

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

Diego_Vialle — Sat, 16 Apr 2022 10:10:22 GMT

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

tamerj1 — Sat, 16 Apr 2022 10:43:29 GMT

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 — Sat, 16 Apr 2022 11:14:50 GMT

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.