Forum Discussion
Dax error
hello Diportee97
i might be wrong but i think [Avg Satisfaction pm] and [Avg Wait Time pm] are taking value from wrong measure.
as you can see below, those pm value have all same value because they are using same exact DAX and same measure.
[Patient Visit pm] is using [Patient Visit] which i think this is correct
[Avg Satisfaction pm] is using [Patient Visit] instead of using [Avg Satisfaction Score]
[Avg Wait Time pm] is using [Patient Visit] instead of using [Avg Wait Time]
if i change the measure to the corresponding measure, i think the value looks more sensible.
Hope this will help.
Thank you.
I don't really understand your Dax and I don't think it really tally with my already established Dax,I would love if you can view and check the pbix file i sent earlier
hello Diportee97
i might be wrong but i think [Avg Satisfaction pm] and [Avg Wait Time pm] are taking value from wrong measure.
as you can see below, those pm value have all same value because they are using same exact DAX and same measure.
[Patient Visit pm] is using [Patient Visit] which i think this is correct
[Avg Satisfaction pm] is using [Patient Visit] instead of using [Avg Satisfaction Score]
[Avg Wait Time pm] is using [Patient Visit] instead of using [Avg Wait Time]
if i change the measure to the corresponding measure, i think the value looks more sensible.
Hope this will help.
Thank you.