Forum Discussion

Gusdate2's avatar
Gusdate2
Helper I
3 years ago
Solved

Calculate Error Rate from two tables

Thank You for looking at this post.   I have been given 2 tables, I do not control or have input into what I am given. The first is a list of actions performed by team members. It contains the Tea...
  • tamerj1's avatar
    tamerj1
    3 years ago

    Gusdate2 

    It is better to unpivot the type1 and type2 columns and have them as Attribute - Value

tamerj1's avatar
tamerj1
Community Champion
3 years ago

Gusdate2 

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?

Gusdate2's avatar
Gusdate2
Helper I
3 years ago

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.