Solved: DECLARACIÓN DEL CASO EN DAX

MEGHAMONTY · ‎10-15-2020

Aquí está mi declaración de caso en SQL

CASO CUANDO T4. SALES_CHANNEL IN (X,Y,Z) ENTONCES SUM(T3. CUSTID)/SUM(T2. TRANID)

ELSE SUM(T1. TICKETID)/SUM(T2. TRANID)

ELSE 0 END AS NEW_RATIO

Empecé con este DAX, pero no puedo conseguir el cambio o SI trabajo aquí

NEW_RATIO- DIVIDE(SUM(T1. TICKETID),SUM(T2. TRANID),0)

MattAllington · ‎10-15-2020

Tratar

•If(T4[SALES_CHANNEL] IN ?X,Y,Z',divide(SUM(T3[CUSTID]),SUM(T2[TRANID])),divide(SUM(T1[TICKETID]),SUM(T2[TRANID])))SUM(T1[TICKETID]),SUM(T2[TRANID])))

* Matt is a Microsoft MVP (Power BI) and author of the Power BI Book Supercharge Power BI.

View solution in original post

MattAllington · ‎10-15-2020

Tratar

•If(T4[SALES_CHANNEL] IN ?X,Y,Z',divide(SUM(T3[CUSTID]),SUM(T2[TRANID])),divide(SUM(T1[TICKETID]),SUM(T2[TRANID])))SUM(T1[TICKETID]),SUM(T2[TRANID])))

* Matt is a Microsoft MVP (Power BI) and author of the Power BI Book Supercharge Power BI.

DECLARACIÓN DEL CASO EN DAX

Helpful resources

Join us for Microsoft Power Platform Conference

Check it Out!

The Power BI Community Show