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 All,
This is a very specific question. In Power BI Designer, I'm working with exam data where the column headers are different course titles along with the assignment (ex: ADAExam, ADAAssignment, etc). Using DAX, I want to create a measure that will average an individual column (ADAExam) that filters out blank cells as well as the value 0. I know I can get around blank cells using AVERAGEA, but I'm not positive I'm filtering around 0 properly. What I have is: CALCULATE(AVERAGEA(Table1[ADARes]), Table1[ADARes] <> 0)
Designer seems to accept that, but when I drag the measure out into the canvas, it gives a warning sign saying that it "cannot retrieve the data for this visualization."
Any help with the formula or insight as to why this is happening would be very helpful!
Thanks
Try changing the visualization type to a score card or table.
Unforunately I've already tried that and I've got the same message for each.
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 |
---|---|
112 | |
97 | |
84 | |
67 | |
59 |
User | Count |
---|---|
150 | |
120 | |
99 | |
87 | |
68 |