Forum Discussion
Helper IIHelp Please.. Custom Colum Filter Value Doesn't Match Measure Value
Helper IIHi MNedix
Really appreciate your help! think we're close and just confirmed my thought that the issue can be with the date but not sure how to work it out...
1. I did this one previously that's why the one I sent has a v2 because this one has the same result (see snapshot below)
2. now #2 recommendation, I think it still flagged the customers as with Purchase (shows netsales value) but the problem there is that their NetSales were done not within the filtered date range of Sept 27. If you notice that the first 14 had NetSales_CBL values and their equivalent NetSales_CBL_Forum values, but you have another 2 showing (not a complete list) and they have values in NetSales_CBL_Forum (column) but they don't have a value in the NetSales_CBL (measure)
If it would further help, the Customer list that I placed in there is from a table that's joined to the sales table, where as the sales table has dates of sales, itemname, sales value etc..
Solution SageI think the issue is deeper into the data model, you should not have the two circled values in there and the empty value in between them is also an error which should not appear. It's quite difficult to understand where this is coming from without looking at the model.
What is the NetSales_CBL measure?