Group by Dax functions

Hi Anonymous ,

Try this:

Enabled for requested dealer = 
VAR CurrentAnchor = 'Table'[Anchor Config ID]
VAR CurrentAnchorDealer =
    CALCULATE ( MAX ( 'Table'[Dealer] ), CurrentAnchor = 'Table'[Target Config ID] )
VAR CountOfTargetDealer =
    CALCULATE (
        COUNT ( 'Table'[Target Config ID] ),
        ALLEXCEPT ( 'Table', 'Table'[Anchor Config ID], 'Table'[Target Config ID] )
    )
RETURN
    IF (
        CurrentAnchorDealer <> BLANK (),
        "Yes",
        IF ( CountOfTargetDealer >= 2 && CurrentAnchorDealer = BLANK (), 
        "Yes", 
        "No" )
    )

# of dealers target config mapped to =
CALCULATE (
    COUNT ( 'Table'[Target Config ID] ),
    ALLEXCEPT ( 'Table', 'Table'[Anchor Config ID], 'Table'[Target Config ID] )
)

Best Regards,

Icey

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