Forum Discussion

mstew55's avatar
mstew55
Frequent Visitor
1 year ago

Count Unique Values based on another column, repeat value rows

Hello, i have one table. Same client name can repeat 50 times, but different records based on other rows. How can count the number of clients, with all blank rows in another column? some clients can ...
mstew55's avatar
mstew55
Frequent Visitor
1 year ago

Awesome Sauce!!!! WOrks perfectly! Is it possible to do it in a column, to indicate which client by row, did not have a sale?

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi mstew55 ,

I think you could try creating a new table to accomplish what you need.

Firstly I create a table as you mentioned.

Then you can choose to create a new table and here is the DAX code.

NewTable = 
VAR _ClientsWithSales = 
    SUMMARIZE(
        FILTER(
            'Table',
            'Table'[Sold] = "y"
        ),
        'Table'[Client]
    )
RETURN
DISTINCT(
    FILTER(
        'Table',
        NOT('Table'[Client] IN _ClientsWithSales)
    )
)

Again you can choose the form you want under Report view.

 

 

Best Regards

Yilong Zhou

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