Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
User | Count |
---|---|
87 | |
85 | |
68 | |
67 | |
64 |
User | Count |
---|---|
210 | |
118 | |
116 | |
81 | |
74 |