Forum Discussion

mifrasmm's avatar
mifrasmm
Helper I
9 years ago

Card Visualization Value

Hi ,

 

I m using direct query to fetch some live data's from SQL, currently i have 2 CARD with the result, Is there anyway i can minus (-) the value from one card to other.

 

I need one more card saying Avaialble = (DIP FLEET - Currently in USE)

 

 

Need Help

6 Replies

  • Phil_Seamark's avatar
    Phil_Seamark
    Microsoft Employee
    9 years ago

    Hi mifrasmm

     

    You could try creating three measures.  The first two to be the sum of each of the columns and then the last being the difference.

     

    Sum of Dip Fleet = sum('Table'[Dip Fleet])

Sum of Currently in use = sum('Table'[Currently in Use])

Difference = [Sum of Dip Fleet] - [Sum of Currently in use]
    • mifrasmm's avatar
      mifrasmm
      Helper I
      9 years ago

      Hi Phil,

      Thanks for reply.

       

      DIP FLEET is just text box.