power query to filter the Aggregated Column only

I have table FactSales with columns at weektype-> week->facility->product hierarchy as below:
WeekType (Fiscal Year/ calendar year)
FACILITY_ID,
Product_ID,
UNIT_QTY,
YearID,
WeekID,
yearweek,
SALES_DOLLARS,
COST_DOLLARS

Other dimension table:

• 1 table is facility_dim and has columns like FACILITY_ID, region, division, manager.
• 2 table is product_dim and has columns like Product_ID, category, dept, family.
• 3 table is year-week table - it has columns like weektype( fiscal or ad week), year, week, yearweek

1. Relationship :
   FactSales - facility_dim on FACILITY_ID (1- many)
   FactSales - product_dim on Product_ID (1- many)
   FactSales - year-week on combination of (weektype + yearweek) (1- many)

It worked when all the aggrgations done in power bi and with the realtionships above.

I used direct query to pull the FactSales data because of lot of data (refresh failed otherwise)

But with direct query too has limitation to pull amount of data. FactSales has 9 billion row and power bi crashes when pulling the data even thru direct query

, so eventually I want to use below direct query and use the product_dim and facility_dim attirbutes as filters for that aggregated query.

Here is my aggr query from fact table that I want to use as direct query ( I want to display the aggr numbers based on the slicers)
select
sum(SALES_DOLLARS) as SALES_DOLLARS
,sum(COST_DOLLARS) as COST_DOLLARS
,sum(SALES_DOLLARS)/sum(UNIT_QTY) as SalesPerUnit
,sum(COST_DOLLARS)/sum(UNIT_QTY) as CostPerUnit
,sum(COST_DOLLARS)/sum(SALES_DOLLARS) as %_CostSales
from FactSales
where WeekType = 'Fiscal Week' // use the values selected from single valued slicer from year-week here as parameter//
and YearID = '2025' // use the values selected from single value slicer from year-week here as parameter//
and WeekID in(1, 2...) // use the values selected from multivaluedslicer from year-week here as parameter//
and FACILITY_ID in (11,22,33,...) // use the values selected from multivalued slicer from facility_dim here as parameter//
and product_id in (1,2,3,...) // use the values selected from multivalued slicer from product_dim here as parameter//

I can't use the attributes like year, week , facility, product etc in select and group by , because i think it wil give the same issue, at this hierarchy i have 9 billion rows. 4.5 billion for Fiscal year and 4.5 for calendar year

How do I do this in power bi?