Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi All,
Need help
I have below table as source , I want to create a easure that gives me count of exact matched addresses, where there are multiple rows of exact same address. single row should not be considered.
Address | Type |
11, XYZ Lane , Postcode :123 | CT |
11, XYZ Lane , Postcode :123 | H |
11, XYZ Lane , Postcode :123 | R |
5, XYZ Lane , Postcode :124 | CT |
5, XYZ Lane , Postcode :124 | R |
6, XYZ Lane , Postcode :32 | CT |
6, XYZ Land , Postcode :32 | H |
9, XYZ Lane , Postcode :12 | CT |
Example Measure -> Exact Match address should be 2 here ,
address 11, XYZ Lane , Postcode :123 and 5, XYZ Lane , Postcode :124 are exact match here with multiple rows.
Can someone please help me in writing the measure?
Thanks in advance.
Solved! Go to Solution.
@AOD,
Try this measure:
Count Exact Match =
VAR vTable =
ADDCOLUMNS (
VALUES ( 'Address'[Address] ),
"@Count", CALCULATE ( COUNT ( 'Address'[Address] ) )
)
VAR vResult =
COUNTROWS ( FILTER ( vTable, [@Count] > 1 ) )
RETURN
vResult
Proud to be a Super User!
@AOD,
Try this measure:
Count Exact Match =
VAR vTable =
ADDCOLUMNS (
VALUES ( 'Address'[Address] ),
"@Count", CALCULATE ( COUNT ( 'Address'[Address] ) )
)
VAR vResult =
COUNTROWS ( FILTER ( vTable, [@Count] > 1 ) )
RETURN
vResult
Proud to be a Super User!
User | Count |
---|---|
139 | |
113 | |
103 | |
73 | |
63 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |