Forum Discussion

BLM's avatar
BLM
Icon for Helper I rankHelper I
8 years ago
Solved

AVERAGE

hii i'm trying calculate the value average of a group of products. I attached a image with the column target:   i don't know calculate this measure, anyone can help me, please.   thank
Need Help
  • Phil_Seamark's avatar
    Phil_Seamark
    8 years ago

    Hi BLM

     

    I have uploaded a simple PBIX file using your sample data set and it shows the measure working.  The only way it can come up with another figure is if there is other data in the model that we can't see.  Have a look at this and see what you think.

     

    https://1drv.ms/u/s!AtDlC2rep7a-oi35BPacpxPxFVty

     

     

Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
8 years ago

Hi,

 

Share the link from where i can download your file.

Phil_Seamark's avatar
Phil_Seamark
Icon for Microsoft Employee rankMicrosoft Employee
8 years ago

Hi BLM

 

I have uploaded a simple PBIX file using your sample data set and it shows the measure working.  The only way it can come up with another figure is if there is other data in the model that we can't see.  Have a look at this and see what you think.

 

https://1drv.ms/u/s!AtDlC2rep7a-oi35BPacpxPxFVty

 

 

  • BLM's avatar
    BLM
    Icon for Helper I rankHelper I
    8 years ago

    thank, it's work like I need.

     

    thank you