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've created the table below, which details all of our important Master Opportunities in Salesforce (11 total). Based on this information I want to provide the user with a % of those Opportunities that we've deemed "Power of One" (meaning involves agencies across our network). That total is 10.
Thus, the formula should should exhibiting 90.9% [10/11]. However, I'm not able to configure how to COUNT only the rows of the current visualized table- which again, is 11 (as opposed to the entire # of rows in the ENTIRE TABLE, which is 10K+). As you can see it's returning 100%.
Here's the current formula:
Any help is appreciated.
I believe the formula should be something like this:
Ok, but what is the restriction for "Po1 (to use)" to get the 10 values?? cause if you just do
COUNT(Opportunity[Po1 (to use)])
it seems like you should get the 11, right? i.e. the 11 rows that are active in the filter context stemming from the two filters you described
Please mark the question solved when done and consider giving a thumbs up if posts are helpful.
Contact me privately for support with any larger-scale BI needs, tutoring, etc.
Cheers
Hi @AlB ,
Thank you for the quick reply.
The 11 are from 2 denoting:
The 10 come from a New Column I created from the following formula:
Basically, the table is used to illustrate our Top Opportunities, and the Po1 column denotes which ones involved multiple agencies. I want to then show the % of the Top Opps that are Po1.
Hi @Tschwenn
I see 11 rows in the table visual you are showing. Why is that? Where is the 10 coming from? And the 11 (i.e., the currently visualized table)? What filters are active on the table that will determine those 10 rows for the denominator in your formula and, alos, what filters will determine the 11?
Please mark the question solved when done and consider giving a thumbs up if posts are helpful.
Contact me privately for support with any larger-scale BI needs, tutoring, etc.
Cheers
@AlB:
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 |
---|---|
54 | |
25 | |
23 | |
15 | |
11 |
User | Count |
---|---|
76 | |
60 | |
46 | |
17 | |
12 |