New table with dates

[Danielwood]

Hi, I have a database which contains loads of data, with some key columns being used to feed my PBI pages.

one thing I am trying to create is a scatter diagram which looks at active entries in the database, then where they have a delivery date in October for example, plot that on the graph. However I can't get my calculation to work on just active records.

i did wonder if it's easier to have a separate table created which pulls the information into it, then I can use this rather than the main table.

the key columns of data would be

Unique ID	Status	Delivery Date
1	Active	10/10/24
2	Active	10/10/24
3	Closed	10/10/24
4	Active	15/11/24

in this example I would expect to plot 2 records in October and 1 in November. The other slight nuisance is the delivery dates will go on into next year too, but ideally my graph would have the current month first.

[dharmendars007 · Accepted solution]

Hello @Danielwood , 

Thanks for your post, I assume you are looking to filter only active records in the Power bI for the sample records you have provided, you can use the measure like this below..

Measure - Calculate(Countrows("Your Table name"), Status = "Active")

Thanks
Dharmendar S

If you find my reply useful please like and mark it as solution.

[Danielwood]

I actually stumbled upon a fix completely by accident. If I use a line graph rather than scatter, filter the visual to only show active, it worked. Thank you for taking the time to respond