cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Frequent Visitor

Qué parámetros IF no funcionan al despivoar la medida a filas

Hola a todos

Estoy atascado en un punto cuando creé la salida de WhatIF Medida funciona bien aquí :-

Cortadora XXX -8Rebanada AAAA -10Rebanada ZZZ -11Cortadora AAA -65
Ejercicio 2018Ejercicio 2019FY 2020Revisado
Xxx80.0085.0070.0062.00
Yyy70.0085.0065.0055.00
Zzz80.0085.0063.0052.00
Aaa80.0085.005.00(60.00)

Fórmula de medida JFYI ( JFYI Measure Formula)

SUMX(Total, IF(Total[Financial Item] á "XXX" , FY 2020 + 'Slicer XXX'[Change Value]),IF(Total[Financial Item] á "YYY" , FY 2020 + 'Slicer YYY'[Change Value]) ,IF(Total[Financial Item Item] ] á "ZZZ" , FY 2020 + 'Slicer ZZZ'[Change Value]) , IF(Total[Financial Item]- "AAA" , FY 2020 + 'Slicer AAA'[Change Value]) ),FY 2020))))

Pero cuando trato de unpivot Table de la manera siguiente con estas medidas no actualiza el valor de la cortadora

Tabla de resumen (Resumid Table)
Contador var á COUNTROWS(FILTERS('P&L'[Línea de negocio]))
VAR T1 - SUMMARIZE(Total,Total[Línea de negocio],Total[Financial Item],"Año","FY 2018", "Valor", Total[Total FY 2018])
VAR T2 - SUMMARIZE(Total,Total[Línea de negocio],Total[Financial Item],"Año","FY 2019", "Valor", Total[Total FY 2019])
VAR T3 - SUMMARIZE(Total,Total[Línea de negocio],Total[Elemento financiero],"Año","RFC 2020", "Valor", Total[Total RFC 2020])
VAR T4 - SUMMARIZE(Total,Total[Línea de negocio],Total[Elemento financiero],"Año","RFC revisado 2020", "Valor",
SUMX(Total, IF(Total[Financial Item] á "XXX" , FY 2020 + 'Slicer XXX'[Change Value]),IF(Total[Financial Item] á "YYY" , FY 2020 + 'Slicer YYY'[Change Value]) ,IF(Total[Financial Item] • "ZZZ" , FY 2020 + 'Slicer ZZZ'[Change Value]) , IF(Total[Financial Item]- "AAA" , FY 2020 + 'Slicer AAA'[Change Value]) ),FY 2020))))) )
devolución
UNION(T1,T2,T3,T4)
1 REPLY 1
Highlighted
Super User IX
Super User IX

Re: Qué parámetros IF no funcionan al despivoar la medida a filas

@PK_PBIBoss , para unpivot probar este

https://radacad.com/pivot-and-unpivot-with-power-bi



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

Helpful resources

Announcements
Ignite

Microsoft Ignite

This will be a conference that you do not want to miss!

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Don't miss the Power BI Dev Camp this week!

August Community Highlights

Check out a full recap of the month!

August 2020 CYST Challenge

Check out the winners of the recent 'Can You Solve These?' community challenge!

Experience what’s next for Power BI

Join us for an in-depth look at the new Power BI features and capabilities at the free Microsoft Business Applications Launch Event.