Forum Discussion

TTO's avatar
TTO
New Member
3 years ago

Visual Showing a Single Calculated Figure

Hi,

 

I have two counted values that I get from two different tables. I want to show the net figure (A total count - B total count) as a single figure in a visual.  Not refering to two columns which can be summed or difference worked out. Two columns like number of invoices vs number of scans. see the pic below. is there an easy way to do this?

 

 

Tutorial Requests

3 Replies

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Super User
    3 years ago

    Hi,

    Create a single column Dim Table.  This column should be the connecting column in both tables.  Create a relationship (Many to One and Single) from the two tables to this third table.  To your visual, drag the field from the Dim table.  Your new measure should be

    Measure = [Measure1]-[Measure2]

    Hope this helps.

    • TTO's avatar
      TTO
      New Member
      3 years ago

      Thanks Ashish

       

      Added more detail to the orignial post. dont want to add a table. Looking for a visual which will show the net.