Forum Discussion
Anonymous
9 years agoNot applicable
Weighted Measure
Hello to all, I am trying to do some dashboards for Logistics departmento and I am having trouble calculating a weighted measure. I have the calculated columnes "Lead Time" and "Dif Date". L...
- 9 years ago
Anonymous
If you use AllSelected instead of All maybe give you the expected result.
Anonymous
9 years agoNot applicable
Hello BhaveshPatel,
Thank you for the fast reply. But I dont have all the columns in the same table...
I tried with this:
Lead Time Ponderado test = SUMX( EM ; [Lead Time (columna)] * DIVIDE( EM[Unidades] ; CALCULATE( SUM( EM[Unidades] ); ALL( EM ) ) ) )
But this only applies correctly if I look at the total, if I apply any filter through a slicer sith measure isn't correct anymore.
It's the " ALL ( EM ) " from the calculate part that has to be variable, but I don't know how to do it.
Vvelarde
9 years agoCommunity Champion
Anonymous
If you use AllSelected instead of All maybe give you the expected result.
- Anonymous9 years agoNot applicable
Wow... it was that easy...
thank you so much :D