Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to 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.
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.
@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 ))
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
105 | |
78 | |
67 | |
63 |
User | Count |
---|---|
148 | |
107 | |
106 | |
83 | |
70 |