Forum Discussion

Anonymous

Not applicable

7 years ago

Solved

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.

v-frfei-msft
7 years ago
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
Filter -Help!.pbix28 KB

9 Replies

Ashish_Mathur
Super User
7 years ago
Hi,

Share the link from where i can download your PBI file.
- Anonymous
  Not applicable
  7 years ago
  Hi Ashish_Mathur -
  I am new to this and it is for a project. Your help means SO MUCH!!!
  - Ashish_Mathur
    Super User
    7 years ago
    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.
v-frfei-msft
Community Support
7 years ago
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
Filter -Help!.pbix28 KB
- v-frfei-msft
  Community Support
  7 years ago
  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

Related content