Forum Discussion

ShaneHi's avatar
ShaneHi
Frequent Visitor
2 years ago
Solved

DAX Not Recognising Another Dax

Hi,

 

I'm just looking for a quick bit of help with a Dax Query. I'm a very basic user of BI so the codes I've used are probably over complicated!

 

I have the below Dax Query which works fine getting the totals I need:

 

 

Sum of Feedback Scores New = IF(SUMX('VTM - Data','VTM - Data'[Does Feedback contain Text?]+'VTM - Data'[Overall Satisfaction Question]+'VTM - Data'[Recommend]+'VTM - Data'[Convenience Question])=0,"",SUMX('VTM - Data','VTM - Data'[Does Feedback contain Text?]+'VTM - Data'[Overall Satisfaction Question]+'VTM - Data'[Recommend]+'VTM - Data'[Convenience Question]))

 

 

But I then wanted to create another Dax to simply do a count (so that I can then get a percentage). 

 

This should work fine (it did in another test but now I can't get it working

 

SUM of Feedback Received NEW = CALCULATE(COUNT('VTM - Data'[Sum of Feedback Scores New]),FILTER('VTM - Data','VTM - Data'[Sum of Feedback Scores New ]>0))

 

 

The issue I now have is the first part of the count, it doesn't recognising the "Sum of Feedback Scores New" column (despite it being a Whole Number valued column.

 

Once I have it working I wanted to bring the previous calculated measure vs another dax query to get an average:

 

 

% Feedback vs Meetings = CALCULATE([SUM of Feedback Received NEW])
/ CALCULATE([No. Of Meetings])

 

Any help will be greatly appreciated!

 

  • I think I solved it myself now so thanks. This can be closed

3 Replies