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
)
Zubair_Muhammad's avatar
Zubair_Muhammad
Community Champion
7 years ago

gowrishankar65

 

Try with following

 

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