This should be a quick one if you have the order of operations down. My modeling is star schema and the division calculation is correct, however when I try to subtract the result from 1 to get the % I get an error.: ‘not enough memory to complete operation’.
I am assuming my order of operation needs to be optimized. All the info is here in the variables. Please let me know which part of the measure needs to be updated. Thank you!
I used Summarize columns and created a calculated column that pulls in ‘1’ as the MAX value and it worked. However, this is not optimal because it is a calculated column that I am adding to the fact table. Is there another way to introduce the value of ‘1’ to each row but not summarize in the grand total, using a measure instead?
Bumping this post for more visibility.
Hi @GeffBLS - Please share a sample PBIX file for us to look into this further.
Thanks
Ankit J
@GeffBLS How many columns are there in the report?
Hello @GeffBLS, it’s been a while since we got a response from you.
Just following up if you still need help with your inquiry?
If you do, kindly provide the information the experts requested above so they can help you further.
In case there won’t be any activity on it in the next few days, we’ll be tagging this post as Solved.