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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

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
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.