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.

Anonymous's avatar
Anonymous
Not applicable
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.