Need to filter a list of contracts by their status and show only ones with a specific status

[akemr]

Hi all,

I have a dataset that consists of a list of contracts, each of which has one of the following statuses: Active, Inactive, Inactive (Stalled), Inactive (Expired), Inactive (Pursuit).

In PBI Desktop, I've created a matrix visual and picked the relevant fields from the dataset. I have a total of 67 contracts and all of them are appearing with the appropriate information. However, I wish to show only the contracts that have either Active or Inactive status.

I have a measure to calculate these contracts which number to 59. So i wish to show only these 59 contracts in the matrix visual. Any ideas on how to do this?

I'm fairly new to PBI so any help is appreciated, thanks 🙂

[amitchandak · Accepted solution]

@akemr , if you have only that measure if will filter .

measure = calculate(count(contracts[ID]), filter(contracts, contracts[Status] in {"Active","Inactive"}))

But other measures without those filters can show more data. So you can use a slicer to filter data or visual level filter to filter status = active and inactive

[akemr]

Thanks @amitchandak , I used a slicer visual to filter them and then hid the slicer visual as this is a permanent change.