Forum Discussion
How can I make this more efficient?
rgu101 instead of sharing DAX code, you should share a sample pbix file with the data model and explain what you are trying to achieve. Read this post to get your answer quickly.
https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
Due to sensitive information, I'm unable to provide a sample pbix file. However, the data model is very simple since it's one large table that contains survey responses.
Here is an abridged example of the data table:
Date Question Group Question Outreach ID Location Positive Response
January A Q1 aaa111 Location1 True
January A Q2 aaa111 Location1 False
January A Q3 aaa111 Location1 True
March B Q6 bbb222 Location3 True
March B Q7 bbb222 Location3 True
March B Q8 bbb222 Location3 True
April A Q1 ccc333 Location1 False
April A Q2 ccc333 Location1 False
April A Q3 ccc333 Location1 True
April C Q1 ddd444 Location2 False
April C Q5 ddd444 Location2 False
April C Q4 ddd444 Location2 False
There are different question groups that may have common questions with other question groups. And each grouping of rows is based on the outreach ID to distinguish unique survey responders. The goal of my DAX code is to produce a matrix that returns the percentage of positive responses by location.
However, I also want it to show the positive response rate for the whole enterprise after collapsing the top Question row (hence the HASONEVALUE function since it doesn't properly return the positive response rate for the whole enterprise without it).
Currently, all the values in the individual cells are produced by a calculated measure with the DAX code, so I'm asking for advice on how to reduce run-time and CPU usage.
Thank you!
