Forum Discussion

sam_nik12345's avatar
sam_nik12345
Helper II
4 years ago
Solved

row wise filter

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 havin...
Need Help
  • v-chenwuz-msft's avatar
    v-chenwuz-msft
    4 years ago

    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's avatar
amitchandak
Super User
4 years ago

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 ))