Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Issue with Totals

Hi team, this is the issue I am having   Here below is my query   km/stop = VAR AVGKMS = AVERAGE(E3table_1[KM]) return if(hasonevalue(E3table_1[ManInd]),AVGKMS,SUMX(VALUES(E3table_1[ManInd]),...
Need Help
  • parry2k's avatar
    parry2k
    6 years ago

    Anonymous these will be two different measures , one Avg Kms Measure and 2nd will be Measure1

     

    AVG Kms Measure = AVERAGE(E3table_1[KM])

Measure1 = 
IF ( HASONEVALUE(E3table_1[ManInd]),
[AVG Kms Measure],
SUMX(
SUMMARIZE ( VALUES(E3table_1[ManInd]), E3table_1[ManInd], "AvgKms",[AVG Kms Measure] ),
[AvgKms]
)
)

     

Anonymous's avatar
Anonymous
Not applicable
6 years ago

i understand, thank you 

parry2k's avatar
parry2k
Super User
6 years ago

Anonymous these will be two different measures , one Avg Kms Measure and 2nd will be Measure1

 

AVG Kms Measure = AVERAGE(E3table_1[KM])

Measure1 = 
IF ( HASONEVALUE(E3table_1[ManInd]),
[AVG Kms Measure],
SUMX(
SUMMARIZE ( VALUES(E3table_1[ManInd]), E3table_1[ManInd], "AvgKms",[AVG Kms Measure] ),
[AvgKms]
)
)

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Thank you, this worked