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]
)
)

     

Ashish_Mathur's avatar
Ashish_Mathur
Super User
6 years ago

Hi,

Do these measures work?

AVGKMS = AVERAGE(E3table_1[KM])

Measure1 = if(hasonevalue(E3table_1[ManInd]),AVGKMS,SUMX(SUMMARIZE(VALUES(E3table_1[ManInd]),E3table_1[ManInd],"ABCD",[AVGKMS]),[ABCD]))

Hope this helps.

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Sorry Ashish, this is giving me error 

    • Ashish_Mathur's avatar
      Ashish_Mathur
      Super User
      6 years ago

      Hi,

      Does this work?

      AVGKMS = AVERAGE(E3table_1[KM])

      Measure1 = if(hasonevalue(E3table_1[ManInd]),[AVGKMS],SUMX(SUMMARIZE(VALUES(E3table_1[ManInd]),E3table_1[ManInd],"ABCD",[AVGKMS]),[ABCD]))

      If it does not, then share the link from where i can download the PBI file and clearly show the visual where my measure is not working.

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        sorry unfortunately i cannot share the file but the error comes when i type Measure1 =.

        does there need to be a something after 

        AVGKMS = AVERAGE(E3table_1[KM]) to connect the two lines?