My PowerBI visual data is not matching with the source

[Anonymous]

Hi, I'm a beginner in powerbi. I'm working towards getting a Table visual. Here all the column names/measures come from same table and a relationship also has been created between required tables. but Here the values for Pkgs and Tours are matching with the source. but the values for other

[AmiraBedh]

Can you better explain your model ?

[Anonymous]

So I have a Fact table which is connected with two different keys to two different dimension tables. 

The Contracts measure here is not matching with my source data. Pkgs and Tours are also coming from FACT but they are mathching 100% across all filters. please find the below screenshot for overview of the model.

[AmiraBedh]

Can you provide some data ? the syntax of your measure, the current input and the expected output ?

[Anonymous]

Here are the necessary measures. 

Channel Detail =

SWITCH(

    TRUE(),

    SELECTEDVALUE('DIM_PORT_EFFORT_VW'[ACCTG_DEPT]) IN {"5100", "5102", "5103"},

    SELECTEDVALUE('DIM_PORT_EFFORT_VW'[LOCTN_DESCR]),

    SELECTEDVALUE('DIM_PORT_EFFORT_VW'[ACCTG_DEPT]) IN {"5110", "5106"},

    SELECTEDVALUE('DIM_PORT_EFFORT_VW'[LOCTN_TP_DESCR]),

    SELECTEDVALUE('DIM_PORT_EFFORT_VW'[ACCTG_DEPT]) = "5101",

        SWITCH(

            TRUE(),

            SELECTEDVALUE('DIM_LEAD'[ARRIV_OWNER_CD]) IN {"1", "2"}, "Owners",

            SELECTEDVALUE('DIM_LEAD'[ARRIV_OWNER_CD]) = "3" &&

            SELECTEDVALUE('DIM_LEAD'[ARRIV_RESERV_CD]) = "2", "Non Owner - Exchanger",

            SELECTEDVALUE('DIM_LEAD'[ARRIV_OWNER_CD]) = "3" &&

            SELECTEDVALUE('DIM_LEAD'[ARRIV_RESERV_CD]) = "4", "Non Owner - MRW",

            SELECTEDVALUE('DIM_LEAD'[ARRIV_OWNER_CD]) = "3" &&

            SELECTEDVALUE('DIM_LEAD'[ARRIV_RESERV_CD]) IN {"5", "6", "7"}, "Marketing Arrivals",

            SELECTEDVALUE('DIM_LEAD'[ARRIV_OWNER_CD]) = "3" &&

            SELECTEDVALUE('DIM_LEAD'[ARRIV_RESERV_CD]) IN {"3", "8", "14", "15"},

                SWITCH(

                    TRUE(),

                    ISBLANK(SELECTEDVALUE('DIM_LEAD'[SRC_SEG_CD])), "Null",

                    SELECTEDVALUE('DIM_LEAD'[SRC_SEG_CD]) = "000000", "000000 Segment",

                    LEFT(SELECTEDVALUE('DIM_LEAD'[SRC_SEG_CD]), 7) = "RRRRRRR" ||

                    SELECTEDVALUE('DIM_LEAD'[SRC_SEG_CD]) = "XXXXXXX", "Other",

                    "Non Owner - Renter"

                ),

            "Other"

        ),

    SELECTEDVALUE('DIM_PORT_EFFORT_VW'[CHANL_DESCR])

)

Tour Type =

IF (

    ISBLANK(DIM_LEAD[PKG_PURCH_DT]),

    "Direct Tour", "Package Tour"

)

---

Effort = IF ( SELECTEDVALUE('DIM_LEAD'[Tour Type]) = "Package Tour", SELECTEDVALUE(DIM_PORT_EFFORT_VW[SRC_LEAD_ORIGIN_SRC_CD]), "Direct Tour")

---

Contracts = (

        SUM('FACT_TOUR_SLS'[GROSS_CONTR_COUNT]) -

        SUM('FACT_TOUR_SLS'[RESC_CONTR_COUNT]) -

        SUM('FACT_TOUR_SLS'[DFLT_CONTR_COUNT]) -

        SUM('FACT_TOUR_SLS'[RETURN_CONTR_COUNT]) +

        SUM('FACT_TOUR_SLS'[RETURN_CANCEL_CONTR_COUNT])

---

I expect the results below