Forum Discussion

as1195's avatar
as1195
Icon for Helper I rankHelper I
2 years ago

Dynamic Weighted Average DAX

Hi , We have a requirement wherein based on measure results and availability(not blank) will have to calculate score as per the given weightage shown below Note : All the measures have result of -1...
Need Help
as1195's avatar
as1195
Icon for Helper I rankHelper I
2 years ago

Thank You for your reply.
I tried with switch but that also seems to be taking same amount of time.

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi as1195 ,

I suggest you to download DAX studio to check the timestamp used for each DAX statement.
It can tell you which statements in the DAX you are using are consuming more time and you can try to modify those statements.

Best Regards,
Dino Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.