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
Icon for Super User rankSuper 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?
  • Ashish_Mathur's avatar
    Ashish_Mathur
    Icon for Super User rankSuper User
    6 years ago

    Hi,

    Sorry but i cannot help if you cannot share any data.

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      i understand, thank you 

      • parry2k's avatar
        parry2k
        Icon for Super User rankSuper 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]
)
)