- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
DAX - Calculating weekly average with conditions
I have the following DAX calculation to calculate average weekly total distance for the squad for only players that trained that week (and therefore excluding injured or ill players). I code whether they train or not daily and have used this is the filter expression.
As shown in the photo below I also did a similar dax calculation but removed the filter at the end. By adding the filter the total distance is lower. However, when I have calculated this separately, the average total distance should be 35,000 for those that trained as you are no longer including players that have 0 for that week. I am not therefore sure why this difference has occurred and any help on this would be greatly appreciated.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
Do not include sensitive information or anything not related to the issue or question.
If you are unsure how to upload data please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...
Please show the expected outcome based on the sample data you provided.
Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...

Helpful resources
Join us at the Microsoft Fabric Community Conference
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Power BI Monthly Update - February 2025
Check out the February 2025 Power BI update to learn about new features.

Subject | Author | Posted | |
---|---|---|---|
10-30-2024 11:30 AM | |||
08-27-2024 06:13 AM | |||
09-27-2024 04:38 AM | |||
10-09-2024 09:44 AM | |||
08-14-2024 11:41 AM |
User | Count |
---|---|
29 | |
15 | |
11 | |
10 | |
8 |
User | Count |
---|---|
22 | |
16 | |
15 | |
14 | |
14 |