Forum Discussion

Tommyvhod's avatar
Tommyvhod
Icon for Helper II rankHelper II
6 years ago
Solved

Issue with meaure total

Hi All  I created a measure to make a weighted average in production. The formula works but the total of measure is not correct. I have found multiple topics about this but I was unable to modify t...
  • Anonymous's avatar
    Anonymous
    6 years ago

    Hi Tommyvhod ,

     

    Below one may work for you, but it might be a bit slow

    Sum = 
	SUMX(
		KEEPFILTERS(Values(Data[Operacia]))
	,
		CALCULATE([allsum])
	)

     

sturlaws's avatar
sturlaws
Icon for Resident Rockstar rankResident Rockstar
6 years ago

Hi Tommyvhod, can you to create a new measure like this:

Allsum Final =
IF ( HASONEVALUE ( Data[Operacia] ); [allsum]; SUMX ( data; [allsum] ) )

 

Cheers,
Sturla

If this post helps, then please consider Accepting it as the solution. Kudos are nice too. 

  • Tommyvhod's avatar
    Tommyvhod
    Icon for Helper II rankHelper II
    6 years ago

    I added the formula, indeed i tryed similar one earlier. But I get a 1,63K final result. The reality should be around 10.5h