Forum Discussion

isThatAFrog's avatar
isThatAFrog
Frequent Visitor
2 years ago

Filter columns not equal, setup DAX

Hi all,
 
I have a filter but I need "direction" on it, can you help me?
In the last line of the DAX below I need to find the values that are not equal, but I need to know which moves are going in to the currently selected organization and which moves are going out of (I have a filter on the To Organizational unit)

CALCULATE([MC aaMoveCountSum],
    'Mobility All'[move Y/N]="Yes"
    && 'Mobility All'[TO Organizational unit] <> 'Mobility All'[COMING FROM Organizational unit]

I couldnt attach the example data so now I put it below:
Effective dateCOMING FROM Organizational unitCOMING FROM MetierCOMING FROM DomainTO Organizational unitTO MetierTO Domainemployee IDTo grouping
01-01-2022EP/DSO/OFF/PJTProject ManagementIndustrial ProjectsOT/CL/CO/DEVArchitecture PlanningIndustrial Projects2244998OT
24-10-2022OT/CL/CO/OPS/SUPUpstream OperationsOperationsOT/NPRESUpstream OperationsOperations2490467OT
01-01-2022EP/DSO/OFF/PRF/GSAUpstream OperationsOperationsOT/CL/CO/OPS/SUPUpstream OperationsOperations2490467OT
27-07-2022OT/CL/CO/DEVArchitecture PlanningIndustrial ProjectsEP/MENA/NA/LY-TEP/ASS/T&DBusiness DevelopmentStrategy Economics Business2711716EP
01-01-2022EP/DSO/OFF/DEVArchitecture PlanningIndustrial ProjectsOT/CL/CO/DEVArchitecture PlanningIndustrial Projects2711716OT
18-08-2022EP/NSR-NB/NSR/CS-DNK/CS/HR/M&LStrategy EconomicsStrategy Economics BusinessEP/NSR-NB/NSR/NO-TEP/FTI/FINStrategy EconomicsStrategy Economics Business2774590EP
23-05-2022EP/NSR/RUStrategy EconomicsStrategy Economics BusinessEP/NSR-NB/NSR/CS-DNK/CS/HR/M&LStrategy EconomicsStrategy Economics Business2774590EP
15-09-2022EP/NSR/CS-DNK/CS/CCAGeneral Communication RespCommunicationEP/NSR-NB/NSR/CS-DNK/CS/CCAGeneral Communication RespCommunication2925664EP
03-01-2023EP/NSR-NB/NSR/CS-DNK/CS/CCAGeneral Communication RespCommunicationEP/EUR/CS-DNK/CS/CCAGeneral Communication RespCommunication2925664EP
01-01-2022EP/DSO/OFF/PRFQualityHyg Saf Sec Societal Env QualOT/CL/CO/OPSQualityHyg Saf Sec Societal Env Qual2929556OT
06-05-2024OT/CL/CO/OPSQualityHyg Saf Sec Societal Env QualEP/AF/NG-TEP/JVA/FOPS/OFFSOperations General ResponsibilitiesOperations2929556EP
01-01-2022EP/DSO/OFF/PRF/GSAInspectionMaintenance / Inspection / TechnologyOT/CL/CO/OPS/SUPInspectionMaintenance / Inspection / Technology3070361OT
29-05-2024OT/CL/CO/OPS/SUPInspectionMaintenance / Inspection / TechnologyEP/MENA/IQ-RATAWI/OPS/FOP/MIUpstream OperationsOperations3070361EP
08-07-2024OT/R&D/POW/NUM/SCDigital Simulation/STIC R&DResearch Innovation&DevelopptOT/R&D/POW/WINDSupport R&DResearch Innovation&Developpt3233300OT
04-12-2023EP/NSR/CS-DNK/CS/FIN/CCRAccountingFinanceGRP/IP/BS/FP&ACost Control & ReportingFinance3539739GR
03-01-2023EP/NSR/CS-DNK/CS/FIN/TAXTaxes Customs & InsuranceFinanceEP/EUR/CS-DNK/CS/FIN/TAXTaxes Customs & InsuranceFinance3588928EP
01-10-2022EP/MENA/IQ-TEP/MOProfit centre managementStrategy Economics BusinessEP/NSR-NB/NSR/CS-DNK/CS/HR/M&LBusiness DevelopmentStrategy Economics Business3594640EP
03-01-2023EP/NSR-NB/NSR/CS-DNK/CS/HR/M&LBusiness DevelopmentStrategy Economics BusinessEP/EUR/CS-DNK/CS/HR/M&LBusiness DevelopmentStrategy Economics Business3594640EP
01-01-2022EP/DSO/CPH/PRF/ENGUpstream OperationsOperationsOT/CL/CO/TS/PROCESSUpstream OperationsOperations3595956OT
16-08-2022OT/CL/CO/TS/PROCESSUpstream OperationsOperationsEP/NSR-NB/NSR/DK-TEP/ASSET/FOPS/HBUpstream OperationsOperations3595956EP



Need Help

2 Replies

  • isThatAFrog's avatar
    isThatAFrog
    Frequent Visitor
    2 years ago

    I have previously used this filter for one of the directions and flipped it for the other direction for the measure of exits but now I need something dynamic

        //    NOT( CONTAINSSTRING( 'Mobility All'[COMING FROM Organizational unit], "TCS"))&&
        //    CONTAINSSTRING( 'Mobility All'[TO Organizational unit], "TCS")


    The result is something like this: