Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
How can I display same value for Average sales of 3 months measure for all the months?
Example:
Measure - Average sale of 3 months = 300
Code Month Avg Sales qty
M100 Jul 300 600
M100 Aug 300 200
M100 Sep 300 450
@Greg_Deckler That kind of works. Its now showing same value across months but for all codes.
I have different material codes -
Code Month Avg Sales qty
M100 Jul 300 600
M100 Aug 300 200
M100 Sep 300 450
M200 Jul 400 200
M200 Aug 400 600
@Sdhn420 - Use ALLEXCEPT instead of ALL to keep the material code filter.
@Greg_Deckler @amitchandak used this calculate(average(Table[qty]), allexcept(Table, Table[Code])) but its giving different values for all the months.
Hi @Sdhn420 I tested this measure and it worked well like below. Does your data come from the same table or from different tables? If they are in different tables, is there any relationship between them?
Regards,
Community Support Team _ Jing Zhang
@Sdhn420 , Try like
calculate(average(Table[qty]), allexcept(Table, Table[Code]))
@Sdhn420 Perhaps try something like:
Average = AVERAGEX(ALL('Table'),[qty])
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
115 | |
99 | |
88 | |
70 | |
62 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |