Forum Discussion

Vijaya4123's avatar
Vijaya4123
New Member
2 years ago

Context is not working - Total is incorrect

I have two fact tables Inventory and Replacements - Inventory has everything and replacements are the devices that failed. My goal is to calculate the FailureRate by DeptID and I want to classify the Dept as failure if there the dept failure % is more than 50%.

I 'm able to get the measure working with deptID in the table view but not the total number

Sample data

Inventory 
DeptIDSerialNum
345FAC1
345FAC2
345FAC3
4567FAC4
4567FAC5
4567FAC6
2456FAC7
2456FAC8
2456FAC9
2456FAC10
5432FAC11
5432FAC12
5432FAC13
65432FAC14
65432FAC15
65432FAC16
65432FAC17

 

Failures 
DeptIDSerialNumDesignIssue
345FAC1Yes
4567FAC4Yes
5432FAC13No
2456FAC10Yes
65432FAC14No
5432FAC12Yes
65432FAC15Yes
65432FAC16Yes
Need Help

4 Replies

    • ryan_mayu's avatar
      ryan_mayu
      Icon for Super User rankSuper User
      2 years ago

      then let's see your sample data. 

      for dept ID 345, how to calculate the failure %?  is that 33.3%?

       

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Icon for Super User rankSuper User
    2 years ago

    Hi,

    None of the Department failure % is even close to 50%.  Why then is there a 1 appearing in the Dept fail column?