Forum Discussion
Calculate Error Rate from two tables
It is better to unpivot the type1 and type2 columns and have them as Attribute - Value
tamerj1 Thank you again for the response. I can unpivot the errorlog table and create an attribute and value. But again, I need help answering the questions raised above. I have not been able to create a measure to do that. If you, or someone else is able to assist me creating the measures necessary to answer the questions in my previous reply, that would be fantstic. Thank You 🙂
If the type columns in the error table were unpivoted then why not just
DIVIDE ( SUM ( Data[Step Count] ), SUM ( Errot[Value] ) )?
Am I missing something?
tamerj1 I don't think you are missing anything...I unpivoted the error log, but the relationships broke. So in my head I was thinkng "AARRRGGGHHH"
I went to play more and I realized that when I unpivoted, it changed the Month to text. So I changed it back to Date and the relationships came back.
So I created Total Errors and Total Step Count measures and then Error Rate as Total Errors/Total Step Count.
Initial look at that approach was good.
I will try the method you listed above too.
WOOHOO...I am in a good mood now.
Yesterday I spent my time trying to use the related and relatedtable function and brute force creating new summarized tables. I didn't think to unpivot. Thank You sir!!! I am super pleased.