Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi,
I am recreating a graph I have made previously in another report, which worked fine and as far as I can tell everything is set up the same way. I have different measures for each of the different TV channels, and am graphing their awareness over time. For some reason my measures are just a straight line, and wont vary with month on the x axis. The measures and month values are both from separate tables, but each has a column of Unique IDs for each respondent (which are often duplicates as respondents could answer for multiple channels). For the channel awareness table theres a column with Unique IDs that pertains to the respondent and response with the tv channels they said they are aware of and the following measure for each channel which I put in the values bucket:
Solved! Go to Solution.
Hi @Anonymous
Please try below measure.If it is not your case, please share your sample file for us to check.You can upload it to OneDrive and post the link here.Do mask sensitive data before uploading.
How to Get Your Question Answered Quickly
% Channel = CALCULATE ( DISTINCTCOUNT ( 'A1a Service Awareness'[UNIQUEID] ), FILTER ( 'A1a Service Awareness', 'A1a Service Awareness'[Response] = "Channel" ) ) / DISTINCTCOUNT ( 'A1a Service Awareness'[UNIQUEID] )
Regards,
Hi @Anonymous
Please try below measure.If it is not your case, please share your sample file for us to check.You can upload it to OneDrive and post the link here.Do mask sensitive data before uploading.
How to Get Your Question Answered Quickly
% Channel = CALCULATE ( DISTINCTCOUNT ( 'A1a Service Awareness'[UNIQUEID] ), FILTER ( 'A1a Service Awareness', 'A1a Service Awareness'[Response] = "Channel" ) ) / DISTINCTCOUNT ( 'A1a Service Awareness'[UNIQUEID] )
Regards,
Hi @v-cherch-msft ,
Thanks for getting back to me (and apologies for the late reply). I've tried your suggestion but unfortunately it has the same result as my original dax formula. I'm wondering if it's potentially to do with my model relationships? The line graph takes data from a table, Period, that has a unique ID for every row, and whether they responded during that month, and is filtered to only show rows that responded. The channel data comes from another table with the same unique IDs and whether they responded for channels (also filtered to only be rows that responded).
However, when filtered (by columns in the demographics and filters table) the value shown in the graph doesnt change. Furthermore, you can see in the picture below, that for that set of filters, there are only 3 periods available, however all still show on the x axis.
So, I'm not sure what might be causing the problems, as I've been triple checking everything and can't see what the issue is.
Apologies for not being able to share the data, its for a client.
Thanks very much for your help!
User | Count |
---|---|
128 | |
108 | |
99 | |
65 | |
62 |
User | Count |
---|---|
136 | |
113 | |
102 | |
71 | |
60 |