Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
grmumford16
New Member

DAX Issue in Power BI Designer

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

3 REPLIES 3
ashishrj
Power Participant
Power Participant

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.

Is Table1[ADARes] formatted as a number?

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.