Forum Discussion

gowrishankar65's avatar
gowrishankar65
Helper I
7 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

Thanks a lot Zubair,it worked for me :)

  • gowrishankar65's avatar
    gowrishankar65
    Helper I
    7 years ago

    Hi Zubair_Muhammad,

     

    We both are working on the same project. ;)

     

    Thanks Zubair :)

     

    Regards,

    Gowrishankar

  • 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  :)