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! What am I doing wrong?
I am calculating a table cell from the sum of a column in Table 1. I need the sum only if a second column in Table 1 meets my criteria.
Solved! Go to Solution.
Hi @Anonymous,
To new measure:
Oil MMBBLS = VAR sumall = CALCULATE ( SUM ( Table1[Column2] ), ALL ( Table1 ) ) VAR c1 = MAX ( Table1[Column1] ) RETURN IF ( c1 = "Proved Developed Non- Producing", sumall, BLANK () )
For more details, please check the pbix as attached. If it doesn't meet your requirement, kindly share your excepted result to me.
Regards,
Frank
Hi @Anonymous,
To new measure:
Oil MMBBLS = VAR sumall = CALCULATE ( SUM ( Table1[Column2] ), ALL ( Table1 ) ) VAR c1 = MAX ( Table1[Column1] ) RETURN IF ( c1 = "Proved Developed Non- Producing", sumall, BLANK () )
For more details, please check the pbix as attached. If it doesn't meet your requirement, kindly share your excepted result to me.
Regards,
Frank
Hi @Anonymous,
Does that make sense? If so, kindly mark my answer as the solution to close the case please. Thanks in advance.
Regards,
Frank
Hi,
Share the link from where i can download your PBI file.
Hi,
Try this calculated column formula
=IF('1P Reserves'[Column1]="Proved Developed Producing",CALCULATE(SUM('Reserve Run'[OilNet(Mbbl)]),'Reserve Run'[Reserve Category]="Producing"))
Hope this helps.
Thank you!! I am getting the error: "Rename Columns: Model object names must be non-empty". ???
I got it!! How would I do the second row for "non-producing" since I can't create a new column because the new column is already there...? Is it a "new measure"??
Hi,
Please state all your conditions clearly.
@Ashish_Mathur Not sure what you mean? 😕
I need to add the second value under the column "Oil MMBBLS" for the "Proved Non-Producing" category.
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 |
---|---|
108 | |
105 | |
88 | |
74 | |
66 |
User | Count |
---|---|
126 | |
111 | |
100 | |
83 | |
71 |