Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.
I have a tableau measure that is :
Fixed Cliente: Aderencia Ponderada =
{Fixed [Cod Cliente Unif],MONTH([Data fat.1]),[Canal de Distribuição]:IIF(ISNULL([{Calc} Preço Bruto Ponderado (R$/Ton)]/[{Calc} Preço Alvo Ponderado (R$/Ton)]),NULL,[{Calc} Preço Bruto Ponderado (R$/Ton)]/[{Calc} Preço Alvo Ponderado (R$/Ton)],NULL)}
I tried this measure in dax , but when I exploded this measure in other dimension in the same fact (fct_PA_VPP_Custo_CPV) - and this dimension is a column measure ("Grupo Repasse") and have circular dependency to this measure "Fixed Cliente" , this vision no have the same values to have in Tableau.
The vision in Tableau when I exploded the mesure Fixed with dimension "Grupo Repasse"
But if I exploded in the same dimension that have in sumarize, the dax measure is the same in tableau and power bi
how to resolved this in DAX ? I need converting these measure.