Forum Discussion

mifrasmm's avatar
mifrasmm
Icon for Helper I rankHelper 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...
Need Help
Phil_Seamark's avatar
Phil_Seamark
Icon for Microsoft Employee rankMicrosoft 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
    Icon for Helper I rankHelper I
    9 years ago

    Hi Phil,

    Thanks for reply.

     

    DIP FLEET is just text box.

    • Phil_Seamark's avatar
      Phil_Seamark
      Icon for Microsoft Employee rankMicrosoft Employee
      9 years ago
      Oh ok. How do you get the number 117?
      • mifrasmm's avatar
        mifrasmm
        Icon for Helper I rankHelper I
        9 years ago

        Fixed value in text box.

         

        Currently USE is fetching from SQL