Forum Discussion

MichaelSamiotis's avatar
MichaelSamiotis
Resolver I
3 years ago
Solved

Repeating Customers with criteria

Hello all,   I hope you are well and thank you very much in advance for any advice on the below.   I have a table containing Shop,City,Product_id,Purchase_date. I want to count how many customers...
General Comment
Need Help
Show and Tell
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    3 years ago

    It is now resolved with the following:

    RETURN
            CALCULATE(COUNTROWS (
                FILTER (
                    UniqueCustomersTable,
                    SELECTEDVALUE ( 'Fact Sales'[Product_ID] ) = [Product_ID]
                )
            ))
Anonymous's avatar
Anonymous
Not applicable
3 years ago

It is now resolved with the following:

RETURN
        CALCULATE(COUNTROWS (
            FILTER (
                UniqueCustomersTable,
                SELECTEDVALUE ( 'Fact Sales'[Product_ID] ) = [Product_ID]
            )
        ))