Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Var Formula to filter a column summary

Hi All, 

 

I am looking for a var formula that can filter a column with the following measure structure:

 

Rev = Calculate(SUM(Table[Column]),'Table 2'[Column 2]="Filter")

 

Any help would be appreciated!

1 Reply

  • 123abc's avatar
    123abc
    Icon for Community Champion rankCommunity Champion
    2 years ago

    If you want to create a measure that calculates the sum of a column (Column) from Table based on a filter condition in another table (Table 2), you can use the following DAX formula:

     

    Rev = CALCULATE(SUM('Table'[Column]), 'Table 2'[Column 2] = "Filter")

     

     

    It seems like you're trying to create a measure in Power BI using the DAX (Data Analysis Expressions) language. If you want to create a measure that calculates the sum of a column (Column) from Table based on a filter condition in another table (Table 2), you can use the following DAX formula:

     

    DAXCopy code
    Rev = CALCULATE(SUM('Table'[Column]), 'Table 2'[Column 2] = "Filter")

     

    In this formula:

    • CALCULATE is a DAX function used to modify the context in which a formula is evaluated.
    • SUM('Table'[Column]) calculates the sum of the values in the specified column of 'Table'.
    • 'Table 2'[Column 2] = "Filter" is the filter condition you want to apply. It filters 'Table 2' based on the value in 'Column 2' being equal to "Filter".

      Make sure that the column names and table names match your actual data model. Adjust the names accordingly if they are different in your case.

      Remember to replace 'Table' and 'Table 2' with the actual names of your tables and 'Column' and 'Column 2' with the actual column names.

      If you encounter any issues or have additional requirements, feel free to provide more details, and I'll be happy to assist further.

       

      If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.

       

      In case there is still a problem, please feel free and explain your issue in detail, It will be my pleasure to assist you in any way I can.