Var Formula to filter a column summary

Anonymous — Tue, 23 Jan 2024 00:10:34 GMT

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!

Re: Var Formula to filter a column summary

123abc — Tue, 23 Jan 2024 07:26:29 GMT

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.

topic Var Formula to filter a column summary in DAX Commands and Tips

Var Formula to filter a column summary

Re: Var Formula to filter a column summary