topic Return Same Value Using Divide in DAX Commands and Tips

Return Same Value Using Divide

weakneee — Sun, 23 Apr 2023 18:10:43 GMT

Hello!

Hope you're doing well. As the images below, I want to return the same value if the column "TipoMultiplicacao" is "EXTERNA" as an alternate result.

In a nutshell is: If "TipoMultiplicacao" is "INTERNA", divide; if "EXTERNA", don't divide and return the same value"

DAX I'm using:

What I want (in red)

Thanks so much!

Re: Return Same Value Using Divide

Jihwan_Kim — Sun, 23 Apr 2023 18:22:49 GMT

Hi,

I am not sure if I understood your question correctly, but please check the below picture and the attached pbix file.

CustoAula CC = IF ( ReferencialTreinamentos[TipoMultiplicacao] = "Interna", DIVIDE ( ReferencialTreinamentos[Custo], ReferencialTreinamentos[NumeroInteriroHoras] ), ReferencialTreinamentos[Custo] )

Re: Return Same Value Using Divide

weakneee — Sun, 23 Apr 2023 20:03:22 GMT

It worked perfectly!

Thank you so munch, Jihwan!