Display Filtered values in table column

[smith12]

Hello

i'm kind of new in powerbi and don't have much record in coding so i hope anyone could help

my page has a slicer for "items"

i want to display only the filtered items that a cosutmoer didn't buy in a field

the problem is when i pick 2 items for example and only one of them was not bought by a costumer,

i see  all the filtered values from the slicer and not only the ones that the Customers didn't buy

my current measure is:

Measure = IF(DISTINCTCOUNT(View_SalesDashBoard[ItemCode]) < CALCULATE(COUNT(OITM[ItemCode]), ALLSELECTED(OITM[ItemCode])) ,

CONCATENATEX(

VALUES(OITM[ItemCode]) ,

OITM[ItemCode] , "; ", OITM[ItemCode],

ASC) ,

"All Sold")

hope some one could help 🙂

[amitchandak]

@smith12 , you should have two dimensions (separate tables) customer and item

Assume you have measure [sales] from common tables

not sold = concatenatex(VALUES(OITM[ItemCode]), if(isblank([sales] ), [ItemCode], blank() ) )

[smith12]

Hey:)
thanks for the fast reply

i created the measure with the code you wrote
and i added it to my table view but it doesnt show any value(even the ones that are checked in the slicer and sold)

[Anonymous]

Hi @smith12 ,

Could you tell me if your problem has been solved?

If not, could you please provide some simple sample data and expected results?

Best Regards,

Stephen Tao

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