Fileting calculate with a text field.

[amalrio]

Hi all,

I have a mesure which works fine below (image 1). I want to add a filter in the calcualte which is coming from a measure, the filter measure is as below (Image2). when I add this in to the image1 measure it gives me the error of image3.

any quick fix 🙂

thanks a lot for your help.

Image1

Image2

Image3

[amitchandak · Accepted solution]

@amalrio , Try to change first calculate with filter

calculate(sum('Fact-data'[Numeric]), filter('Dim-Metric', 'Dim-Metric'[Matrix_id] =35 && 'Dim-Metric'[Version_id] =[Versonname]))