Forum Discussion
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...
Try this one
Measure = COUNTX ( FILTER ( SUMMARIZE ( ALLSELECTED ( TableName ), TableName[Phone Number], TableName[Invoice Date] ), [Fraud or Valid] = "Fraud" ), 1 )
No,Sir i want the phone number 123456 to be counted as two.
The solution you provided gets me the distinct count of FRAUD numbers but i want the overall count of FRAUD numbers which should be 4 for the table provided above but your formula is giving the count as 3
Try this one
Measure =
COUNTX (
FILTER (
SUMMARIZE (
ALLSELECTED ( TableName ),
TableName[Phone Number],
TableName[Invoice Date]
),
[Fraud or Valid] = "Fraud"
),
1
)
Thanks a lot Zubair,it worked for me :)
Hi Zubair_Muhammad,
We both are working on the same project. ;)
Thanks Zubair :)
Regards,
Gowrishankar
