'Substract from 100% after divide two measures
Created two measures for total check qty and defects qty.after devide it I get defects qty % .But I want get pass qty %.Database don't have any column for the pass qty.My measures as below.
Prd_In_Line_Check = SUM(Prd_in_Line[Operation Checked Qty])
Prd_In_Line_Defects = sum(Prd_in_Line[No Of Defects])
Prd_In_Line_Pass % = 1-DIVIDE(DAX_Measures[Prd_In_Line_Defects],DAX_Measures[Prd_In_Line_Check],BLANK())
.
But the problem is after I drag these measures to Table it doesn't respond to external filters.Its works fine with defects qty % as below.
Prd_In_Line_Pass % =DIVIDE(DAX_Measures[Prd_In_Line_Defects],DAX_Measures[Prd_In_Line_Check],BLANK()).
I want get pass % by substracting.
screnshot as below.
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|

