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.
Hi my friends,
I have some tables in my excel file, the main goal is to show to the company some general indicators of the departments and the goal number of them. So if the result (inserted manually) is between the values of the line, it will change one column with 0=not reached and 1=goal reached.
The problem that I'm facing is to show the total % of all the indicators.
How can I do one Select-from and using the 1 value as a filter?
In SQL would be:
Select percentage
from resultadosabertos
where meta=1
Check some ps pls.
This first ps is the current value of the indicator.
This second ps would be the table that I need to search for the value. The result would actually be 30%.
Thank you!
After importing the excel into Power bi desktop, you could create a visual to display the result by adding a filter as below:
Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @v-juanli-msft , I already did this, the problem is not actually this... =/
The problem that I'm actually facing is that I need to summarize all the results of the tables into one single field.
Example:
Table 1
30%
Table 2
20%
What I need: 50%
Why I need for: 50% / 2 = 25%
25% will be the final indicator, it summarize the result of each indicator and divide by the number of indicators. Can you help me with this?
Thank you anyway!
Best Regards
Bruno
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.