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:

 targetstock
Jan-1812
Feb-1822
Mar-1832
Apr-1842
May-1852

 

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

I want to achieve like below:

 targetstock
Jan-1812
Feb-182 
Mar-183 
Apr-184 
May-185 

 

Kindly help.

 

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.

     

2 Replies

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

  • v-chenwuz-msft's avatar
    v-chenwuz-msft
    Community Support
    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.