Card Visualization Value

[mifrasmm]

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)

[Phil_Seamark]

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]

Hi Phil,

Thanks for reply.

DIP FLEET is just text box.

[Phil_Seamark]

Oh ok. How do you get the number 117?

[mifrasmm]

Fixed value in text box.

Currently USE is fetching from SQL 

[Phil_Seamark]

Any chance you can post a screenshot of the data?

[mifrasmm]

Hi Phil,

Below sorted. I have used new measure to calulate remaining