Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
Hi all,
I need some assistance.
I wanted to calculate the average for each month. The calculation that I want is,
Avg = Sum of Sales in each month / Tot No. of Companies in each month
Is there a DAX measure that I can use to calculate it? Appreciate if someone can help. Tq in advance!
Solved! Go to Solution.
Hi,
I tried to create a sample pbix file like below.
Please check the below picture and the attached pbix file.
Thank u very much Jihwan_Kim for the solution.
Hi,
I tried to create a sample pbix file like below.
Please check the below picture and the attached pbix file.
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 41 | |
| 38 | |
| 36 | |
| 30 | |
| 28 |
| User | Count |
|---|---|
| 128 | |
| 88 | |
| 79 | |
| 67 | |
| 62 |