Forum Discussion
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 display names except 'Active' from 'Active' what sort of formula could I use?
Thanks!
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.
4 Replies
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
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
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.
