Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
Solved! Go to Solution.
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
Hi,
Try this
=CALCULATE(AVERAGE([Unidades]),ALL(Data[PeriodoCalculo]))
Hope this helps.
HI @BLM
A calculation to find the average of the [Unidades] column per [CodArticulo] is as follows: but this looks like what you have. What is the number you are expecting?
media = CALCULATE( AVERAGE('Table1'[Unidades]), FILTER( ALLSELECTED(Table1), 'Table1'[CodArticulo] = MAX('Table1'[CodArticulo] ) ) )
Yes, i'm expecting the average per CodArticulo, but your formula don't work. I attached image with the result.
The values that I expected are in the first image that I attached.
thank
Hi,
Share the link from where i can download your file.
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
thank, it's work like I need.
thank you
User | Count |
---|---|
141 | |
113 | |
104 | |
77 | |
64 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |