PBI Question : Showing single values

[nikkifox]

I have created a table visual which lists "Clients" from one dataset, the "Items" that are purchased by those clients from another dataset, and the "Value" of those items from another dataset.

Dataset "Clients to Items", "Items to Values" and "Clients to Values" are all "one to many" relationships.

The point of the table (which is currently displayed as a matrix), lists the clients with the items underneath and the values of those items.

The end goal is to identify the Clients that only buy one particular item. It doesn't matter which item, but that it's always the same, singular item.

I have applied a countdistinct filter to the items and this shows me count totals for the clients and the items they purchase, e.g. item1 = 2, item2 = 4 and item 3=1. So does give me the desired outcome, but I cannot filter on the total value = 1.

Ideally, I would then like to apply a slicer above the matrix table, whereby you could select the "Item" name and then the matrix below would show only those clients who have only ever purchased that item and not clients that have purchased many items, one of which was the item selected in the slicer.

Can anyone possibly help me with the DAX code or advice how to display this please? I am very new to PBI and DAX and am self teaching via youtube and google and not knowing exactly which function I require to apply is proving a bit difficult.

Thank you so much in advance.

Kind regard

Nikki

 

[nikkifox]

If this helps with a response, please see attached.

Three tables showing you the data I am using to create a table visual in powerbi.

Desired outcome lists Client Names, Items and Billed.

A slicer applied whereby I can choose an Item and the table visual updates to only show those clients who purchase one item, so in the example of the data below I would expect to see Client JKLM and RSTU for the item Payroll, EFGH for the item Tax and ZZZZ for the item Accounts and the value associated.

 

[RoryA]

Unfortunately, pictures of data don't really help us to help you, as we then have to retype everything. If you could post a link to a sample file (eg on OneDrive) or post some usable data using the XL2BB tool, it would make life easier?