Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I have a measure which takes a lot of time to calculate and the value in matrix is not really coming up.
It works , but if people have to wait 5 min to see the values they are not happy. maybe somebody has an idea to optimize my calculation:
HI, @Sonne
I think if you need to optimize the formula of 'DPA '[DPA N-3],
Not sure if it is possible, could you try this formula as below:
previous Period = VAR a = CALCULATE ( 'DPA '[DPA N-3], Period[Period] = "P0" & MONTH ( TODAY () ) - 2 ) VAR b = CALCULATE ( 'DPA '[DPA N-3], Period[Period] = "P0" & MONTH ( TODAY () ) - 1 ) RETURN IF ( ( ( a ) + 0.005 ) <= ( b ), ROUND ( ( a * 100 ), 1 ) & " % " & " " & UNICHAR ( 129093 ), IF ( ( ( a ) - 0.005 ) > ( b ), ( ROUND ( ( a * 100 ), 1 ) ) & " % " & " " & UNICHAR ( 129095 ), ( ROUND ( ( a * 100 ), 1 ) ) & " % " & " " & UNICHAR ( 129094 ) ) )
and if possible, please share your sample pbix file for us have a test.
Best Regards,
Lin
Hello,
thanks for the answer. I tried the formula and it works, but it is not really faster . I think so too, that it is coming from DPA calculation.
Other question : all my measures are in one table. if i choose a measure and insert this into a matrix, are the other measures also calculated ( the one in the table but not in the matrix visualisation?)
does it make a difference if i have 1 table with all measures or more tables with the measures?
hi, @Sonne
If the measure is nested in the current measure which is in matrix visual, it will be calculated two.
For example: in your case, [previous Period] and [DPA N-3] are two measure, and although [DPA N-3] is not in the matrix, but it is nested in [previous Period], so it is calculated in matrix too.
Best Regards,
Lin
Hm ok I understand. if i take now your formular:
hi, @Sonne
For each measure, the variables are Independent.
So for [ColorKPI1], if you want to use variables, you need to define it again.
https://docs.microsoft.com/en-us/dax/var-dax
Best Regards,
Lin
User | Count |
---|---|
128 | |
108 | |
99 | |
65 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |