Forum Discussion
PowerBI: Summary Table like Solution
I am trying to create a visual that tracks a manager's progress toward a goal of 45 connections per quarter. I have a column called meeting type, which within has several different values. Three of t...
Hi, Anonymous
Based on your description, you cannot get the percentage by dividing the column by 45 because there is also data in this column that you don't need. The Filter function is provided in Power BI to filter the data you need. I created the following sample data:
In Power BI, you can obtain a meeting type summary table through the summarize and filter methods:
Table 2 = SUMMARIZE('Table',"sss",CALCULATE(VALUES('Table'[meeting type]),FILTER('Table','Table'[meeting type]="connection")))
How to Get Your Question Answered Quickly
Best Regards
Jianpeng Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.