Forum Discussion
Subtracting by filtered data - Two datasets - New BI user
- 9 years ago
ok, I think I understand what you are after but not 100% sure.
First of all, rather than use the values the way you have been, can you create Calculated Measures on each of your tables.
So on your _custom_eviews_SCReportrepariCodes_6 table create a measure like this:
Count of Calls 6 = CALCULATE( COUNTROWS('_custom_eviews SCReportRepairCodes_6') , FILTER( '_custom_eviews SCReportRepairCodes_6' , [RepairCode] = "EC") )and then something similar on your Materials table. Once you have these as measures you can create a 3rd measure which is the result of the first - the second.
- 9 years ago
In this scenario, I would rather tagging the Efficient Calls into False than substracting the count of Efficient Calls from the True category and adding that amount into False part.
If you use a calculated column to tagging a call is incomplete or not, you may add a nested IF statment like:
IF(RELATED('_custom_eviews SCReportRepairCodes_6'[Repair Code]="EC",False,True))Regards,
ok, I think I understand what you are after but not 100% sure.
First of all, rather than use the values the way you have been, can you create Calculated Measures on each of your tables.
So on your _custom_eviews_SCReportrepariCodes_6 table create a measure like this:
Count of Calls 6 = CALCULATE(
COUNTROWS('_custom_eviews SCReportRepairCodes_6') ,
FILTER(
'_custom_eviews SCReportRepairCodes_6' ,
[RepairCode] = "EC")
)and then something similar on your Materials table. Once you have these as measures you can create a 3rd measure which is the result of the first - the second.