I have a Sales Quantity flowing column in which daily data gets added.
I have slicers for Year and month.
As per the selected slicer, sales quantity should be compared with Sameperiodlastyear and the difference (positive, zero or negative categories) should be segregated so that the count of customers in each category and the corresponding sales quantity sum should be availabe.
Created measures of Total sales and Total sales Last year help me upto the level of populating a table in whcih I get the differences mentioned as the categories stated above.
However, to count the no. of customers falling in each category is where I am facing problem.
The moment I try with a new measure as Positive count=Calculate (Count(partycodes),((Total sales)-(Total sales Last year}}>=0), it considers the overall table values and not individual rows.
So I am trying to create a calculated column..
But am presently stuck with 'circulatory reference' error..
Could you post your table structures(including the measures you're using) with some sample/mock data, and the expected result against the data? So that we can better assist on this issue. It's better that you could also share a sample pbix file . You can upload it to OneDrive or Dropbox and post the link here. Do mask sensitive data before uploading.