Replacing a blank or null value with 0 to show all account records as 1/0

[dswinden]

Trying to provide my sales team with a simple 1 or 0 logic tool to show whether a product is listed at an account or not.  Simple explanation, if a sales person has 20 stores that they call on, i want the sales person to see all 20 stores at once, and show 1 or 0 "Listed" or "Not Listed" based on a measure i have pre-written

The measure I have written to determine if sales are there or not works fine, but only shows stores with sales.  If is calculating the inventory of a store across a 3 month period, and if the sum is greater than 0, it will return a distinct count of 1 based on the count of the POC (retailer) name.

R3M | Listings =

CALCULATE(DISTINCTCOUNTNOBLANK('POC Universe'[POC Name]),filter(distinct('POC Universe'[POC Name]),CALCULATE([R3M | Inventory Level (All Scrapes)])))

I have tried something as simple as =if([R3M | Listings]>0,1,0) but all values return as 0 when this happens.  Below is a simple example of what my data SHOULD look like.

[amitchandak · Accepted solution]

@dswinden , Try like

Switch(true(),

isblank([R3M | Listings]) , blank() ,

[R3M | Listings]>0,1,0)

[dswinden]

Thanks @amitchandak as always!  One of the first to reply to my questions, appreciate it!

I tried what you provided but unfortuneately it still does not show the 0's.  I have a suspicion its due to my data structure so I will tinker a bit with it now.  Will get back to you!