Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

How to show the difference between too clustered columns?

Hallo everybody,

 

i got a cluster column chart that shows the sum of square m² road between a datatable 2016 vs 2019.

 

I want too know where the difference are between the cluster column's?

I want a measure or a new column that exclude the roads with the same square m² in both tables.

The result must be the roads with square m² that exists only in table 2019 with the location. I want this as a drilltrough column.

 

20162019

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

The calculation has to consider a rounding of 1 up or down only if the road match.

 

Can somebody help me?

 

 

Need Help

3 Replies

  • v-piga-msft's avatar
    v-piga-msft
    Resident Rockstar
    7 years ago

    Hi Anonymous,

     

    I'm still a little confused about your scenario.

     

    If it is convenient, could you share some data sample which could reproduce your scenario and your desired output so that I can copy and test.

     

    Best  Regards,

    Cherry

      • Anonymous's avatar
        Anonymous
        Not applicable
        7 years ago

        I'm still waiting for someone te help me with this. Maybe my question is not so clear.

         

        i was thinking about a formula that goes something like this.

         

        if column square m² in table 2016 is equal to column square m² 2019 then do not show in results.

         

        Maybe somebody can help me too shape this formula