create a measure with 5 columns based on on and 2 filter criterias and use this measure as a button

[Aishwaryazanpur]

Dear all,

I am new to PBI, I want to create a measure based on one sinngle table, which involves summing 5 columns from the same table and 2 filter criterias from the same table) ..I tried suing combination of calculate, sum and filter with out success.

I want to use this created measure as a buttoon in PBI.

[v-tangjie-msft · Accepted solution]

Hi @Aishwaryazanpur ,

To create a measure based on a single table, you can use the DAX formula SUMX to sum the values of multiple columns in a table.

MeasureName = SUMX(TableName, [ColumnName1] + [ColumnName2] + [ColumnName3] + [ColumnName4] + [ColumnName5])

You can also add filter criteria to the formula using the FILTER function.

MeasureName = CALCULATE(SUMX(TableName, [ColumnName1] + [ColumnName2] + [ColumnName3] + [ColumnName4] + [ColumnName5]), FILTER(TableName, [FilterColumnName1] = "FilterValue1" && [FilterColumnName2] = "FilterValue2"))

Best Regards,

Neeko Tang

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

[Uzi2019]

@Aishwaryazanpur 
Would you please elaborate what exactly you want to calculate I mean expected outcome. 
And how you want to display?
You can use excel to depict your scenario n share screenshot.