Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago
Solved

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...
Need Help
  • Vvelarde's avatar
    Vvelarde
    9 years ago

    Anonymous

     

    If you use AllSelected instead of All maybe give you the expected result.

     

     

BhaveshPatel's avatar
BhaveshPatel
Super User
9 years ago

You can use something like this with the newly added functionality Invoke Custom Function in Query Editor for this and It would be more creative solution as you can use them for other type of tasks as well.

 

To do so, 

 

1.Add a Blank query and Write the below code:

(Qscore as number, Rscore as number,Sscore as number) => Qscore + Rscore + Sscore

 

M11.PNGM10.PNGM12.PNGM13.PNG

 

 

2. Go to your original query and Under the Add Column Tab, Select Invoke Custom Function.

and Choose the appropriate options and it will give you desire results. 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    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's avatar
      Vvelarde
      Community Champion
      9 years ago

      Anonymous

       

      If you use AllSelected instead of All maybe give you the expected result.

       

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        9 years ago

        Wow... it was that easy...

         

        thank you so much :D