Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

Filter -Help!

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. 

 

 
1 ACCEPTED SOLUTION
v-frfei-msft
Community Support
Community Support

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 () )

Capture.PNG

 

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

Community Support Team _ Frank
If this post helps, then please consider Accept it as the solution to help the others find it more quickly.

View solution in original post

9 REPLIES 9
v-frfei-msft
Community Support
Community Support

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 () )

Capture.PNG

 

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

Community Support Team _ Frank
If this post helps, then please consider Accept it as the solution to help the others find it more quickly.

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

Community Support Team _ Frank
If this post helps, then please consider Accept it as the solution to help the others find it more quickly.
Ashish_Mathur
Super User
Super User

Hi,

 

Share the link from where i can download your PBI file.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/
Anonymous
Not applicable

Hi @Ashish_Mathur -

I am new to this and it is for a project. Your help means SO MUCH!!!

 

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.

 

Untitled.png


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/
Anonymous
Not applicable

@Ashish_Mathur 

Thank you!! I am getting the error: "Rename Columns: Model object names must be non-empty". ???

Anonymous
Not applicable

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.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/
Anonymous
Not applicable

@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.

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.