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
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
