Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi,
I want to calculate how many postcodes are from the same Area Code. I've tried to use a calculated column with this but it doesn't work:
Occurrences = CALCULATE( COUNT([AreaCode]); FILTER(Area; [AreaCode] = EARLIER('Area'[AreaCode])))
To give an example: I want to calculate how many orders are from SE6 or another area.
Solved! Go to Solution.
Solved:
Occurrences = CALCULATE(
COUNT(
LocationandStoreType[AreaCode]
),
FILTER(
LocationandStoreType,
LocationandStoreType[AreaCode]=EARLIER(LocationandStoreType[AreaCode])
)
)
Solved:
Occurrences = CALCULATE(
COUNT(
LocationandStoreType[AreaCode]
),
FILTER(
LocationandStoreType,
LocationandStoreType[AreaCode]=EARLIER(LocationandStoreType[AreaCode])
)
)
User | Count |
---|---|
57 | |
22 | |
21 | |
19 | |
16 |
User | Count |
---|---|
87 | |
87 | |
52 | |
37 | |
23 |