Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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.
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
118 | |
101 | |
71 | |
61 |