My PowerBI visual data is not matching with the source

Question

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 · Answer

Can you better explain your model ?

anonymous · Answer

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 · Answer

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

anonymous · Answer

Here are the necessary measures.&nbsp;Channel Detail = SWITCH(&nbsp; &nbsp; TRUE(),&nbsp; &nbsp; SELECTEDVALUE('DIM_PORT_EFFORT_VW'[ACCTG_DEPT]) IN {"5100", "5102", "5103"}, &nbsp; &nbsp; SELECTEDVALUE('DIM_PORT_EFFORT_VW'[LOCTN_DESCR]),&nbsp; &nbsp; &nbsp; &nbsp; SELECTEDVALUE('DIM_PORT_EFFORT_VW'[ACCTG_DEPT]) IN {"5110", "5106"}, &nbsp; &nbsp; SELECTEDVALUE('DIM_PORT_EFFORT_VW'[LOCTN_TP_DESCR]),&nbsp; &nbsp; &nbsp; &nbsp; SELECTEDVALUE('DIM_PORT_EFFORT_VW'[ACCTG_DEPT]) = "5101",&nbsp; &nbsp; &nbsp; &nbsp; SWITCH(&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; TRUE(),&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; SELECTEDVALUE('DIM_LEAD'[ARRIV_OWNER_CD]) IN {"1", "2"}, "Owners",&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; SELECTEDVALUE('DIM_LEAD'[ARRIV_OWNER_CD]) = "3" &amp;&amp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; SELECTEDVALUE('DIM_LEAD'[ARRIV_RESERV_CD]) = "2", "Non Owner - Exchanger",&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; SELECTEDVALUE('DIM_LEAD'[ARRIV_OWNER_CD]) = "3" &amp;&amp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; SELECTEDVALUE('DIM_LEAD'[ARRIV_RESERV_CD]) = "4", "Non Owner - MRW",&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; SELECTEDVALUE('DIM_LEAD'[ARRIV_OWNER_CD]) = "3" &amp;&amp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; SELECTEDVALUE('DIM_LEAD'[ARRIV_RESERV_CD]) IN {"5", "6", "7"}, "Marketing Arrivals",&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; SELECTEDVALUE('DIM_LEAD'[ARRIV_OWNER_CD]) = "3" &amp;&amp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; SELECTEDVALUE('DIM_LEAD'[ARRIV_RESERV_CD]) IN {"3", "8", "14", "15"},&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; SWITCH(&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; TRUE(),&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ISBLANK(SELECTEDVALUE('DIM_LEAD'[SRC_SEG_CD])), "Null",&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; SELECTEDVALUE('DIM_LEAD'[SRC_SEG_CD]) = "000000", "000000 Segment",&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; LEFT(SELECTEDVALUE('DIM_LEAD'[SRC_SEG_CD]), 7) = "RRRRRRR" || &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; SELECTEDVALUE('DIM_LEAD'[SRC_SEG_CD]) = "XXXXXXX", "Other",&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "Non Owner - Renter"&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ),&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "Other"&nbsp; &nbsp; &nbsp; &nbsp; ),&nbsp; &nbsp; &nbsp; &nbsp; SELECTEDVALUE('DIM_PORT_EFFORT_VW'[CHANL_DESCR]))&nbsp;&nbsp;&nbsp;&nbsp;Tour Type = IF (&nbsp; &nbsp; ISBLANK(DIM_LEAD[PKG_PURCH_DT]),&nbsp; &nbsp; "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 = (&nbsp; &nbsp; &nbsp; &nbsp; SUM('FACT_TOUR_SLS'[GROSS_CONTR_COUNT]) - &nbsp; &nbsp; &nbsp; &nbsp; SUM('FACT_TOUR_SLS'[RESC_CONTR_COUNT]) - &nbsp; &nbsp; &nbsp; &nbsp; SUM('FACT_TOUR_SLS'[DFLT_CONTR_COUNT]) - &nbsp; &nbsp; &nbsp; &nbsp; SUM('FACT_TOUR_SLS'[RETURN_CONTR_COUNT]) + &nbsp; &nbsp; &nbsp; &nbsp; SUM('FACT_TOUR_SLS'[RETURN_CANCEL_CONTR_COUNT])I expect the results below&nbsp;

Forum Discussion

My PowerBI visual data is not matching with the source

4 Replies

Related content

Table Visual not Matching Calculated Visual

PowerBI Visual

PowerBI Visuals API updating issue

PowerBI - Matrix table, hide values used only for a visual calculation

Copilot Narrative Visual in PowerBI