Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello,
I'm looking to create a matrix table that includes a SUM FTE column (see attached) that does the following:
How many ETFs are in surface
How many ETFs are in construction
How many EFTs are in landscaping
Since I'm dealing with a dimension and measure to add to a table, I'm not sure how to move forward. Thank you.
Platform | Product Line | Team | Sum FTEs | Engineer | Project Manager | Designer |
Surface | Facility and Equipment Operations Systems | EC Saas 2 | 7.5 | 0 | 0.5 | 0 |
Construction | aPaaS | Dev | 14 | 0.2 | 0.5 | 0.3 |
Landscape | aPaaS | OC Dev | 7.7 | 0.2 | 0.5 | 0 |
Hi @Nosh10 ,
Could you show us your sample data and expected results? So that we can know your scenario better.
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
What are we looking at source data or output? If source, provide output, if output, provide source.
Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
User | Count |
---|---|
98 | |
90 | |
82 | |
73 | |
67 |
User | Count |
---|---|
115 | |
102 | |
98 | |
71 | |
66 |