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,
I would like to know if there is a way I can get rid off the internal measure formula to just group/sum up items on a table in Power BI.
On the first place, I created the formula below in order to get the total savings by project (considering that each project could contain more than one sub-category/row):
2022 Savings by Project = CALCULATE(CALCULATE(SUM('New Provalido Download'[2022 savings New P]),FILTER(ALLSELECTED('New Provalido Download'),'New Provalido Download'[2022 savings New P]=MAX('New Provalido Download'[2022 savings New P]))),ALLEXCEPT('ID Table','ID Table'[Project ID/Project Name]))
Many thanks in advance!
Solved! Go to Solution.
Hi @tati1292 ,
According to your description, here are my steps you can follow as a solution.
(1) This is my test data.
(2) We can create a measure.
2022 Savings by Project = CALCULATE(SUM('Table'[2022 savings New P]),FILTER(ALLEXCEPT('Table','Table'[Workstream Sub Cat],'Table'[Type2]),'Table'[2022 savings New P]))
(3) Then the result is as follows.
You can refer to the following documents that may be helpful to you:
Grouping Measures in Matrix Table - Power BI - Enterprise DNA Forum
Best Regards,
Neeko Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Neeko,
Thank you so much for your reply. I tried your formula for 2022 Savings by Project but it's excluding the Project ID so it's not giving me the expected result by project I was getting with my previous formula. What I was trying on the first place is getting a SUMIF by Project ID for 2022 Savings since each Project ID could have more than one sub-category depending on the year of the savings as you can see below in Excel:
My goal in Power BI is to get the CY column: =IF(CX8755="Buy-In",CV8755-SUMIF(C:C,C8755,CU:CU),IF(AND(CX8755="Compete/New Buy-In",'PowerBI Download - USD - 01 201'!CV8755=0),0,'PowerBI Download - USD - 01 201'!CV8755-'PowerBI Download - USD - 01 201'!CU8755))
So the two formulas I created in Power BI for this were the following:
Thank you!
Tatiana
Hi @tati1292 ,
According to your description, here are my steps you can follow as a solution.
(1) This is my test data.
(2) We can create a measure.
2022 Savings by Project = CALCULATE(SUM('Table'[2022 savings New P]),FILTER(ALLEXCEPT('Table','Table'[Workstream Sub Cat],'Table'[Type2]),'Table'[2022 savings New P]))
(3) Then the result is as follows.
You can refer to the following documents that may be helpful to you:
Grouping Measures in Matrix Table - Power BI - Enterprise DNA Forum
Best Regards,
Neeko Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
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 |
---|---|
110 | |
94 | |
81 | |
66 | |
58 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |