Forum Discussion

gowrishankar65's avatar
gowrishankar65
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's avatar
    Zubair_Muhammad
    7 years ago

    Sidhartha_1992

     

    Try this one

     

    Measure =
COUNTX (
    FILTER (
        SUMMARIZE (
            ALLSELECTED ( TableName ),
            TableName[Phone Number],
            TableName[Invoice Date]
        ),
        [Fraud or Valid] = "Fraud"
    ),
    1
)
Sidhartha_1992's avatar
Sidhartha_1992
New Member
7 years ago

Actually gowrishankar65 is my senior,we both were trying to find out the solution to this problem so he posted it  :)