Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
KPage
Contributor III
Contributor III

Only want to show data from one "Source" filter

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

Labels (2)
5 Replies
Clement15
Creator
Creator

Hello,

have you tried this ?
sum({<Source={'Warehouse'}>}[CW Sales])

KPage
Contributor III
Contributor III
Author

I am receiving an error. My "CW Sales" are not showing as a "measure" in ther formula. (It is not showing as purple)

KPage_0-1708613283543.png

 

Clement15
Creator
Creator

Your measure must be a master measure, is it possible to create a new identical one by adding only {<Source={'Warehouse'}>} in it ?

KPage
Contributor III
Contributor III
Author

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?

Clement15
Creator
Creator

Try it out with this :
Sum({<Date={ '$(=MaxWeek)' },Source={'Warehouse'}>} [Dollar Sales])