Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Lock values independent of the filter.
The formula is not locking the value so I can calculate percentages in another measure. Where am I going wrong? Can someone help me?
A formula não está travando o valor para que eu calcule percentuais em outra medida. Onde estou errando? Alguém pode me ajudar?
Vendas Serviços =
var TotalServicos =
SUM(dLanServicos[ValorMovimento])
return
CALCULATE(TotalServicos;ALL(fLanNotas[SemLiquidacao]);
FILTER(ALL(fLanNotas);fLanNotas[SemLiquidacao]="S");
FILTER(ALL(fLanNotas);fLanNotas[TipoNegocio]="V");
FILTER(ALL(fLanNotas);fLanNotas[TipoMovimento]="S");
FILTER(ALL(dClientesFornecedores);dClientesFornecedores[APropria]="N")
)
Desde já, obrigado!
Thanks!!
Solved! Go to Solution.
Hello!
For some reason that I do not know, when I made the update of the data the measure presented the result that I expected.
Anyway, thanks for the reply.
Could you please share dummy data and relationships of your tables(fLanNotas,dLanServicos, dClientesFornecedores) , then post expected result here?
Based on above DAX, the measure value will not change if you use fields of fLanNotas table or dClientesFornecedores table to create filters and then use these filters in your visual.
Regards,
Lydia
Hello!
For some reason that I do not know, when I made the update of the data the measure presented the result that I expected.
Anyway, thanks for the reply.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |