row wise filter

[sam_nik12345]

My matrix table looks like below in visualization:

	target	stock
Jan-18	1	2
Feb-18	2	2
Mar-18	3	2
Apr-18	4	2
May-18	5	2

stck is from a different table and having inactive relation with target.

I want to achieve like below:

	target	stock
Jan-18	1	2
Feb-18	2
Mar-18	3
Apr-18	4
May-18	5

Kindly help.

[v-chenwuz-msft · Accepted solution]

Hi @sam_nik12345 ,

You can use UESRELATIONSHIP() function to active the relationship.

Measured =
CALCULATE(
    SUM( 'Table 2'[stock] ),
    USERELATIONSHIP ( 'Table 2'[target], 'Table 1'[target] )
)

Result:

Please share your pbix file without sensitive data if you need more help.

Best Regards

Community Support Team _ chenwu zhu

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

[amitchandak]

@sam_nik12345 , need to understand the stock measure. based on that we need top it on min month

One way is

measure =

var _min = minx(allselected('Date'), Date[Date])

return

calculate(sum(Table[Stock]), filter('Date', Date[Date] =_min ))