Creating a Measured Filter

[Anonymous]

I am looking at subcriptions and I want to see how many active subscriptions we have.

In my column we have the following

What I need to do is create a measure which deducts all of the display names except 'Active' from 'Active' what sort of formula could I use?

Thanks!

[v-yetao1-msft · Accepted solution]

Hi @Anonymous ,

There are two ways to get the data you want. You can refer to either of the two .

(1)A simpler way is setting in Visual filter .You can select ‘Active’ and the return value is what you want .

(2)Create a measure like:

active = CALCULATE(SELECTEDVALUE('Table'[Count of Subscription Status Active]),FILTER('Table','Table'[Subscription Status Display Name]="Active"))

And add a card to display the return value .

Best Regards

Community Support Team _ Ailsa Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[sanalytics]

@Anonymous 

is your Subscription status display Name column or measure?

if it is a column then a simple filter will do your job

Calculate([ count of subscription status active],Subscription status display Name ="Active")

Regards

Sanalytics

[Anonymous]

It's a column! 🙂

With the calculate function how would I filter for one result and then deduct all the others?

e.g. 'Active' - (Archived + Cancelled + Out of stock + Payment Failed + Pending)?

[DataVitalizer]

Hi @Anonymous 

Have you tried applying a filter on that visual from the filter tab?

Did it work ? Mark it as a solution to help spreading knowledge.

A kudos would be appreciated