Forum Discussion

Helper I

1 year ago

[Basic] userelationship on variable table #2

Hello everyone : ) It's might be a basic but I've been stucking for weeks,hope anyone could tell me.. ■trying to do want to calculate schedule fluctuation count. summarize a table for exculdin...

Anonymous

Not applicable

1 year ago

Hi ohnothimagain ,

Based on the description, verify that there is an existing relationship between calendar[Date] and TEST[R_Date].

Then, try using the following DAX formula.

test11 := 
var _tbl = 
    SUMMARIZE(
        'TEST_', 
        'TEST_'[PN], 
        'TEST_'[PO], 
        "@M", MIN('TEST_'[M_Date]), 
        "@R", MIN('TEST_'[R_Date])
    )
var _ftd = FILTER(_tbl, [@M] < [@R])
var _result = COUNTROWS(
    CALCULATETABLE(
        _ftd, 
        USERELATIONSHIP('Calendar'[Date], 'TEST_'[R_Date])
    )
)
return _result

You can also view the following document to learn more information.

USERELATIONSHIP function (DAX) - DAX | Microsoft Learn

Best Regards,

Wisdom Wu

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