RELATED() function removes filters and returns aggregate

[Kevin-Mann]

 I have a DirectQuery model with the below relationship:

Allocations 1--* Positions 1--* Exposures

I have a filter on the Allocations table that gives me an allocation for associated positions by child company.  When I use the RELATED() function, it clears the filter on the Allocations table and returns the sum of all companies with allocations in the child company.  Is there a work-around for this to tell DAX, "I filtered the table for a reason, so please use my filters!"?

Thanks in advance!

KM

[v-yuta-msft]

Hi Kevin-Mann,

How about not use RELATED() function?If still can't achieve what you want , I would recommend you to merge your tables or use DAX function like SUMMARIZEor SUMMARIZECOLUMNS .

Regards,

Jimmy Tao

[Kevin-Mann]

Jimmy,

Thanks for writing back.  Using SUMMARIZE is counter-intuitive, clunky, and is exponentially slower.  I also get an error that there are more than 1M rows, when I expand the date range.  Can I somehow use RELATED in the context of ALLSELECTED?

Kind Regards,

Kevin