Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I only want to show data from the "Warehouse" source. However, when I apply this formula
if (Source <> 'Warehouse',0,[CW Sales])
I am not getting the correct answer. I do not want to include "Online" sales on this page. I think this has something to do with the "0" in the formula. Please see the attached image.
I also do not want to have to select the "Warehouse" filter.
Thank you
Hello,
have you tried this ?
sum({<Source={'Warehouse'}>}[CW Sales])
I am receiving an error. My "CW Sales" are not showing as a "measure" in ther formula. (It is not showing as purple)
Your measure must be a master measure, is it possible to create a new identical one by adding only {<Source={'Warehouse'}>} in it ?
I do have CW Sales as a master measure. This is the expression-
Sum({<Date={ '$(=MaxWeek)' }>} [Dollar Sales])
How would I incorporate only Warehouse sales into this?
Try it out with this :
Sum({<Date={ '$(=MaxWeek)' },Source={'Warehouse'}>} [Dollar Sales])