Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Creating a Measured Filter

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 disp...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    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's avatar
sanalytics
Super User
5 years ago

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's avatar
    Anonymous
    Not applicable
    5 years ago

    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)?