Forum Discussion
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
- Ritaf1983
Super User
Hi ShaneHi
Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...
Please show the expected outcome based on the sample data you provided.
https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523- ShaneHiFrequent Visitor
Apologies but Im unable to share the file. It's over 200mb and has private information!
- ShaneHiFrequent Visitor
I think I solved it myself now so thanks. This can be closed