Forum Discussion
What's wrong with my syntax?
Hi all, I am looking to create a measure that will take a count of cases sold and then return the average of it, however for the life of me I cannot figure out why my syntax is off? I tried using DAX...
bongmw Hi and thanks for response! I should have clarified, the SoldCaseInt is essentially a table to capture whether a case has been sold or not (so it only holds values 1 or 0). What I am trying to do is count how many 1's we have and then take the average of that.
The measure you pasted will essentially just return 1 always as thats the average of 1.
The filter is simply to take only the cases sold by the settlement officers and between those date ranges.
Thanks!