Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers. Get Fabric certified for FREE! Learn more
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] ) )
Check out the April 2025 Power BI update to learn about new features.
Explore and share Fabric Notebooks to boost Power BI insights in the new community notebooks gallery.
User | Count |
---|---|
16 | |
10 | |
8 | |
8 | |
7 |