Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
doingmeheadin
Frequent Visitor

DAX Measure which will identify duplicates within events in progress window

Hi Guys, 

Been stuck on this for a while. 

I would like to build a solution which will identify all the rows which were open at a specific date and then show which of these share the same adress (count duplicate adress). 

This measure will need to be filterable by date so I can table progress. I would like to be able to metrics of the back that would show how many properties have 1 duplicate, how many have 2 etc. 

Row data lookign like this: 

doingmeheadin_0-1687788367775.png

 


Output I would like to replicate :

doingmeheadin_0-1687788076528.png

I can reproduce this table without issue for todays date but I cant get the results to filter to show the number of duplicates on previous days. 

Ideally I would like to be able to produce month on month and year on year figures. 

Any help would be greatly appreciated. 


Tom 





0 REPLIES 0

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.