Return Same Value Using Divide

Question

Hello!&nbsp;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.&nbsp;&nbsp;In a nutshell is: If "TipoMultiplicacao" is "INTERNA", divide; if "EXTERNA", don't divide and return the same value"&nbsp;&nbsp;DAX I'm using:&nbsp;&nbsp;What I want (in red)&nbsp;&nbsp;Thanks so much!

jihwan_kim · Accepted Answer

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

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

&nbsp;

Forum Discussion

Return Same Value Using Divide

2 Replies

Related content

Measure returning incorrect value

Date Different return wrong value

divide 2 values

MAXX Returning duplicate values

Return "Specific value" from table 1, if not found, return value from table 2