Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
I have a mailers table where each row shows a mailer sent to a customer.
There are times when we send more than one mailer in a month to a customer.
I'd like to create a measure that tells me how many customerIDs show up more than once?
Basically count rows where count(customerids)>1
Solved! Go to Solution.
Calculation1 = COUNTROWS(
FILTER( VALUES (Sheet1[CustomerID]), COUNTROWS(Sheet1)>1 )
)
Calculation2 = COUNTROWS(
FILTER( VALUES ( Sheet1[CustomerID] ) , [Count of CustomerID] > 1 )
)
https://drive.google.com/file/d/17TZgQPIN18Ri8LoeNsJpkWNz_1fJKnbB/view?usp=sharing
@Anonymous
Calculation1 = COUNTROWS(
FILTER( VALUES (Sheet1[CustomerID]), COUNTROWS(Sheet1)>1 )
)
Calculation2 = COUNTROWS(
FILTER( VALUES ( Sheet1[CustomerID] ) , [Count of CustomerID] > 1 )
)
https://drive.google.com/file/d/17TZgQPIN18Ri8LoeNsJpkWNz_1fJKnbB/view?usp=sharing
Thank you so much @Arjunarao !
Many folks had similar answers, appreciate the feedback from everyone, thanks!!
Hi,
In a slicer, select any one month. Drag this measure to a card visual
=COUNTROWS(FILTER(VALUES(Table1[CustomerID]),COUNTROWS(Table1)>1))
Hope this helps.
You could use logic like the following:
COUNTROWS( FILTER( VALUES( Table1[CustomerID] ) , [Count of CustomerID] > 1 ) )
User | Count |
---|---|
80 | |
74 | |
62 | |
61 | |
45 |
User | Count |
---|---|
108 | |
97 | |
88 | |
81 | |
61 |