Forum Discussion

Danielwood's avatar
Danielwood
Helper I
2 years ago
Solved

New table with dates

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 th...
Need Help
  • dharmendars007's avatar
    dharmendars007
    2 years ago

    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.

dharmendars007's avatar
dharmendars007
Memorable Member
2 years ago

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's avatar
Danielwood
Helper I
2 years ago

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