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
i have data like below:
I wrote dax for avg amount:
Avg amount = CALCULATE(AVERAGE(‘table1[Amount]),filter(ALLEXCEPT(table1,table1
[Date],table2[Area])))
How to find total amount 5.31 based on avg amount?
Solved! Go to Solution.
@Anonymous,
You may try a similar way as shown here.
Hi @Anonymous,
Based on your screenshot, you seem to be trying to get the average of average. Example for 4/11, the average is 0.45 and then you want to calculate the average for all the dates.
Create two measures using these:
Avg of Amt = AVERAGE ( 'Table'[Amount] )
Avg of Avg of amt= AVERAGEX ( ALL ( Table[Date] ), [Avg of Amt] ) )
The above formula calculates the sum of the average for each day then divides it by the number of days.
Proud to be a Super User!
@Anonymous,
You may try a similar way as shown here.
Thanks for sharing the link
based on date and area wise average amount is calculated
we can see single date(04/04/2018) amount is 0.05 and average amount 0.05
single date multiple times(04/09/2018) amount is 0.95, 1.5, 1, 0.5 , 0.65 and average amount 0.92
based on the above average amount calculations . Find total average amount : 5.31
can you please assist?
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 |
---|---|
110 | |
94 | |
82 | |
66 | |
58 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |