Forum Discussion

Helper I

8 years ago

Solved

DAX Calculation unique Count

Hi Team, I am trying to create report for Retail Analytics. I have a table with Columns - Phone Number, Invoice Date which has duplicates. With Invoice Date I am getting No. of visits (Calc...

Need Help

Zubair_Muhammad

8 years ago

Sidhartha_1992

Try this one

Measure =
COUNTX (
    FILTER (
        SUMMARIZE (
            ALLSELECTED ( TableName ),
            TableName[Phone Number],
            TableName[Invoice Date]
        ),
        [Fraud or Valid] = "Fraud"
    ),
    1
)

Zubair_Muhammad