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.
Hello,
Hoping sopmeone can help me average a total.
I am trying to average the "AvgDailyChg" row. I would greatly appreciate a solution to this problem!
I dont know if this will help, but I was given this formula from @Icey, but I do not know how to plug in my Fields or measures with the formula that I was given. And I am not even suire if this forula will work, fyi.
Measure = IF ( NOT ( HASONEVALUE ( 'Table'[YearMonth] ) ) && SELECTEDVALUE ( 'Table'[Product] ) IN { "B", "C" }, AVERAGE ( 'Table'[Value] ), SUM ( 'Table'[Value] ) )
Here are the fields I have for the dataset I am working with.
@jonnyA ,
Not clear,
if you help with more detail and a sample of it. I wiil try to help you out.
Regards,
Manikumar
Proud to be a Super User!
Thank you in advance for your help!
I think I am getting closer to my answer using the formula below. I am trying to average the Total. As you can see from the screen shot the Total is summing the 3 months.
Here is the formula I am currently using ...
Measure = IF ( ( NOT ( HASONEVALUE ( 'Table'[YearMonth] ) ) && SELECTEDVALUE ( 'Table'[Product] ) IN { "B", "C" } ) || ( NOT ( HASONEVALUE ( 'Table'[YearMonth] ) ) && NOT ( HASONEVALUE ( 'Table'[Product] ) ) ), AVERAGE ( 'Table'[Value] ), SUM ( 'Table'[Value] ) )
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 |
---|---|
42 | |
21 | |
21 | |
14 | |
14 |
User | Count |
---|---|
43 | |
39 | |
33 | |
18 | |
17 |