Forum Discussion

Helper IV

5 years ago

Solved

Filter replacement inside matrix with visual filter

I have a matrix displaying a sum of sales quantity and I have a slicer picking date periods. I am displaying the sum of sales qty. I am also displaying the sum of sales for all dates (using ALL...

Ashish_Mathur
5 years ago
Hi,

You may download my PBI file from here. In both tables, you had dragged the fields from the wrong tables. Also, i have corrected your measure.

Hope this helps.

Super User

5 years ago

Hi,

You may download my PBI file from here. In both tables, you had dragged the fields from the wrong tables. Also, i have corrected your measure.

Hope this helps.

Helper IV

5 years ago

Thanks, Ashish. As you noticed, I did something wrong that which looked right to my inexperienced eye.

Adding a filter in calculate is done as in line 1 below, not as in line 2 below.

Thank you.

SalesInPeriod1 = calculate(sum([SalesQty]),'dim DatePeriod'[DatePeriod]=1)

SalesInPeriod1 = calculate(sum([SalesQty]),FILTER('dim DatePeriod',[DatePeriod]=1))

Ashish_Mathur
Super User
5 years ago
You are welcome.