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.
I need to average the column CONFIABILIDAD [column calculadted: New Measure] (Picture 2) excluding the column META (Picture 1). The formula DAX (Picture 4) that I am using is averaging everything (it is not excluding the column META) and the "wrong" result is 81.83% (Picture 3). The correct answer should be 96.67%. I appreciate the help
Solved! Go to Solution.
Please try something like below, using filter to exclude product not required.
Measure 7 = AVERAGEX(KEEPFILTERS(filter(values('Product'[Category]),'Product'[Category] <> "Bikes")),CALCULATE([Measure 5]))
Regards,
AJ
Do Like Post if response seems good and Worth liking.
Do Mark as Solution if response resolved your Issue.
Actaully, Didn't get time to add few things yesterday.
1) You don't need KeepFilters here. As per PBI Docs, KeepFilter is only required with Calculate and CalculateTable to keep context from changing.
2) When using a Measure inside Aggregate function, you don't need to add Calculate function. Don't have an exact theory however as per my understanding, using Measure an internal/default Calculate is automatically added.
Regards
AJ
Please try something like below, using filter to exclude product not required.
Measure 7 = AVERAGEX(KEEPFILTERS(filter(values('Product'[Category]),'Product'[Category] <> "Bikes")),CALCULATE([Measure 5]))
Regards,
AJ
Do Like Post if response seems good and Worth liking.
Do Mark as Solution if response resolved your Issue.
Actaully, Didn't get time to add few things yesterday.
1) You don't need KeepFilters here. As per PBI Docs, KeepFilter is only required with Calculate and CalculateTable to keep context from changing.
2) When using a Measure inside Aggregate function, you don't need to add Calculate function. Don't have an exact theory however as per my understanding, using Measure an internal/default Calculate is automatically added.
Regards
AJ
Thanks AnkitBI,
I did it without using KeepFilters and it worked perfectly. Very thankful
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 | |
81 | |
66 | |
58 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |