Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
Solved! Go to 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.
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
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
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)?
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
105 | |
97 | |
79 | |
66 | |
62 |
User | Count |
---|---|
145 | |
113 | |
105 | |
85 | |
65 |