Forum Discussion

Pbiuserr's avatar
Pbiuserr
Icon for Post Prodigy rankPost Prodigy
3 years ago

Measure takes long to execute

Hello, I wonder why this measure is so slow. First I create INTERSECT from ID's from both dim and fact table  Planned SKU = COUNTROWS(INTERSECT ( VALUES (DimTable[ID] ), VALUES (FactTable[ID] )...
Need Help
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
3 years ago

Pbiuserr , Try like, I think simple countrow should also work

 

Planned SKU by date =
CALCULATE (
countrows(filter(Fact, not(isblank(related(DimItem[ID])) )),
FILTER (
ALL ( 'date' ),
'date'[Date] <= MAX ( 'date'[Date] )
)
)