Forum Discussion

PowerBInewb's avatar
PowerBInewb
Frequent Visitor
9 years ago
Solved

Subtracting by filtered data - Two datasets - New BI user

My company uses a series of resolve codes in our ticketing system. I have filtered these codes into a distinct count. This distinct count needs to be removed from our incomplete percentage that is di...
  • Phil_Seamark's avatar
    Phil_Seamark
    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.

  • v-sihou-msft's avatar
    v-sihou-msft
    9 years ago

    PowerBInewb

     

    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,