Forum Discussion

Anonymous's avatar
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.     
Need Help
  • v-frfei-msft's avatar
    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

Anonymous's avatar
Anonymous
Not applicable
7 years ago

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"??

Ashish_Mathur's avatar
Ashish_Mathur
Super User
7 years ago

Hi,

 

 

Please state all your conditions clearly.

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    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.