Forum Discussion

Naveen_SV's avatar
Naveen_SV
Helper IV
7 years ago

How to Take Difference between two table when we are taking counts of other Primary ID

Hi 

My Sceneria is i have a two table Table A and Table B where

Table A has matrix column of Primary Key vs group of City and calulating total count of primary key from Table b

table B has matrix of Column of Primary key vs Group of City from Table A and Calulating Count of Primary key from Table A i want to see the differnece between these two table. I wan to project the difference in Stacked Chart

1 Reply

  • Stachu's avatar
    Stachu
    Community Champion

    Can you add tables A and B (in format that can be copied to PowerBI) from your model with anonymised data? Like this (just copy and paste into the post window).

    Column1Column2
    A1
    B2.5