Setting Fixed Variables in a Table?

[michaeldmeehan]

I am trying to keep track of the products we sell but finding it difficult to monitor since my sales data drive what I see in my table. For example, if we sell 20 products, but the specific retailer only purchased 12 of them, I only see 12 products in my table. Is there a way to "set the assortment" (or dependent variable) and see the status regardless of sales or inventory data? I am looking to see the status of all 20 products - whether or not there is sales or inventory data feeding in. Thanks in advance for any help!

[Anonymous]

Hi @michaeldmeehan ,

According to you description, sales table was filtered to only show the 12 products of the specific retailer. If retailer, products and sales are in the same table, you could create a calculated table with all retailer and use SELECTEDVALUE() function to choose specific retailer and IF() function to determine whether the retailer has purchased products.

Pbix as attached, hopefully works for you. If i misunderstood your meaning, please share some sample data and expected result to us. Please make sure you don't any Confidential Information before sharing any data.

Best Regards,

Jay

Community Support Team _ Jay Wang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[rajulshah]

Hello @michaeldmeehan,

Can you provide the structure of your data or sample data that you have?