Sum if one column of the data table equals a single measure value (Problem: expected single value)

[Anonymous]

Hey there,

I need to calculate the sum of a specific column (let's call it column3) of the main data table with two conditions being met:

1.  filter column1 by a text value that's is being given by means of a measure (!)
2.  filter column2 by a normal string (not the actual problem)

The measure is calculated as follows:

• SUMMARIZE(TableX; ColumnX)

A slicer (single selection) ensures that the measure only has one single value as an ouput, which can be seen in the screenshot of the Measure:

However, when I want to calculate the sum, there's an error ("MeasureTable.Measure: A table of multiple values was supplied where a single value was expected).

I thought that I should be able to filter by the measure as it is only one value, right? 

Many thanks in advance!

[parry2k]

@Anonymous hey it is very hard to answer the question without knowing data model, what your measure looks like and what you are trying to achieve. Read this post to get your answer quickly.

https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490