Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.
Hi,
Can anyone optimize the below query. it's taking 15 seconds to load when I run in Dax studio. and this measure I am using for conditional formatting.
CAGR = Var matrix1 = CAGR (% TY v LLY)]
Var matrix2 =
CALCULATE(CAGR (% TY v LLY)],
ALL('STATES')
, ALL('STORES')
, ALL('PRODUCT')
)
Return
IF(matrix1 > matrix2, "GREEN", "RED")
Thanks in advance.
Didn't understand! has your question been optimized or not?
Hi
Anyone have idea to optimize this measure?
and also I 've created this measure in report level. and data is coming from SSAS model. if i create same measue in ssas model and deploy then add to report. will it be optimse? becuase this measure comes from then SSAS model.
anyone help me in this?
Thanks.
your measure not worked it gives "RED" for every category.
my question in your measure, why you did not take three tables?
CAGR = Var matrix1 = CAGR (% TY v LLY)]
Var matrix2 =
CALCULATE(CAGR (% TY v LLY)],
REMOVEFILTERS()
)
Return
SWITCH( TRUE,matrix1 > matrix2, "GREEN", "RED")
Hi @Ahmedx
Thank you for your quick response.
In the above you dax why you did not consider three tables of states, stores and product. ?
will removefilters appply to 3 tables whitout metioning in formaula. ?
Thanks
User | Count |
---|---|
85 | |
78 | |
70 | |
49 | |
41 |
User | Count |
---|---|
111 | |
56 | |
50 | |
42 | |
40 |