I want to show the A-B into the another table visualization is it possible please guide me,

[Anonymous]

[Anonymous]

For your understanding @Bibiano_Geraldo 

[Bibiano_Geraldo]

Great, can you provide a sample power bi file  with no sensitive information?

[Anonymous]

i will send you but where i have to sent file with you @Bibiano_Geraldo 

[Bibiano_Geraldo]

Upload o onedrive and share the link forr downoad here in comments.

[Anonymous]

These are the columns i am using in the table visulization @Bibiano_Geraldo Please reply me.

[Anonymous]

When user selecting the date in slicer in table A ,
in table he selected another date in slicer table B,
both the date values i want to show in the table visual dynamically please anyone help me regarding this.

[Bibiano_Geraldo]

Sorry @Anonymous ,

Its still no clear for me to sugest your the accurate solution, i see that in your example, the dates in slicers are diferent, but the tables are showing the same thing, can you provide more context?

Be clear, give me step by step of what you need and i'll help you to find the correct solution.

[Bibiano_Geraldo]

Hi @Anonymous ,

Please, can your provide more details of what you need to do? if possible share the desired output.

[Anonymous]

Please do needful @Bibiano_Geraldo 

[Anonymous]

I want to show the Difference between both tables like A-B .
in the c table.

[Bibiano_Geraldo]

Hi, understood now, what are you using to display values in these tables? Measures?

If possible share file with no sensitive data, or show me the measures used

[Anonymous]

A_Units_Selected_Date =

CALCULATE(

    SUM(A[Units Total]),

    A[Report Date] = SELECTEDVALUE('A'[Report Date]),

    ALLEXCEPT(A, A[Report Date], A[Brand], A[Opportunity Name], A[Category/Specialty], A[Agency business])

)

the above one i have used in table B also same

and finally i have used this comparisin measure

Units_Comparison =

IF(

    ISBLANK(A[A_Units_Selected_Date]),

    [B_Units_Selected_Date],

    IF(

        ISBLANK([B_Units_Selected_Date]),

        A[A_Units_Selected_Date],

        A[A_Units_Selected_Date] - B[B_Units_Selected_Date]

    )

)


i don't know if its correct or not please help me regarding this @Bibiano_Geraldo 

[Anonymous]

C =

VAR FilteredA =

    FILTER(

        'A',

        'A'[JoinKey] = MAX('A'[JoinKey])  -- Ensure proper context for 'A' table

    )

VAR FilteredB =

    FILTER(

        'B',

        'B'[JoinKey] = MAX('B'[JoinKey])  -- Ensure proper context for 'B' table

    )

RETURN

    SELECTCOLUMNS(

        FILTER(

            CROSSJOIN(FilteredA, FilteredB),

            'A'[JoinKey] = 'B'[JoinKey]

        ),

        "Pipeline Year A", 'A'[Pipeline Year],

        "Week Number A", 'A'[Week Number],    

        "Brand A", 'A'[Brand],                  

        "Opportunity Name A", 'A'[Opportunity Name],  

        "Units Total Diff", 'A'[Units Total] - 'B'[Units Total],

        "Jan Diff", 'A'[Jan] - 'B'[Jan],

        "Feb Diff", 'A'[Feb] - 'B'[Feb],

        "Mar Diff", 'A'[Mar] - 'B'[Mar],

        "Apr Diff", 'A'[Apr] - 'B'[Apr],

        "May Diff", 'A'[May] - 'B'[May],

        "Jun Diff", 'A'[Jun] - 'B'[Jun],

        "Jul Diff", 'A'[Jul] - 'B'[Jul],

        "Aug Diff", 'A'[Aug] - 'B'[Aug],

        "Sep Diff", 'A'[Sep] - 'B'[Sep],

        "Oct Diff", 'A'[Oct] - 'B'[Oct],

        "Nov Diff", 'A'[Nov] - 'B'[Nov],

        "Dec Diff", 'A'[Dec] - 'B'[Dec]

    )
this measure also i have used to show the difference but its showing all the zeros