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

Hi Zubair_Muhammad,

 

We both are working on the same project. ;)

 

Thanks Zubair :)

 

Regards,

Gowrishankar