Forum Discussion
Dax Optimization
Hi, It is taking 5 mins to visual cross filter with others. I would like to know how i can optimize this dax code to perform better or anyother alternative. Time taken:- ...
No clue if this works, but give it a try! 🙂
3 Months Rolling Average =
VAR Table =
SUMMARIZE(
VALUES ( 'UCD Data'[Sold_To_Ultimate_DUNS_Desc] ),
"Filter 1" , [Dynamic Segment DP DDD] ,
"Filter 2" , [Dynamic Segment % UCD] ,
"Rolling Avg" , [Measure Selection Rolling 3 Months Avg]
)
VAR A =
SUMX(FILTER( Table , [Filter 1] <> BLANK() , [Rolling Avg])
VAR B =
SUMX(FILTER( Table , [Filter 2] <> BLANK() , [Rolling Avg])
VAR c =
IF (
ISFILTERED ( 'DP DDD Dynamic Segmentation'[Buckets] ),
A,
IF (
ISFILTERED ( 'Dynamic Segement %UCD'[Bucket] ),
B,
[Measure Selection Rolling 3 Months Avg]
)
)
RETURN
c
Br,
J
tex628 ,
I have tried your logic. It is not happening. After applying the cross filtering is not happening.😐
Thanks,
Akhil.
What are the individual load times of these three measures?
[Dynamic Segment DP DDD]
[Dynamic Segment % UCD]
[Measure Selection Rolling 3 Months Avg]
