Divide a card output?

[Gumberculeez]

Hey All;

I'm looking to create a DSI gauge for our company.  I'm few direct queries to get the number for the equation (3 month coGS, and inventory values), but I need to do some simple math with them....

question is how 🙂

I need to take my card value for CoGS and divide by 90.  but it's a direct query measure that got me there.  

Same with the inventory value.  I'm going to need simple math with that as well.

Can I do this?

[Gumberculeez]

On the surface that works... :).  However, my configuration is a bit more complex than that. Here's what I have:

Daily Sales Inventory:

1. Card that has the last 3 months of cost of goods sold.  this is from a table, includes 2 columns and a number of "accounts" from one column

2. Card that has a measure showing our sellable inventory.

The wall I'm hitting is I need to divide that Cost of Goods sold card by 90.  It seems I need a measure that will do everything the card does, than divides by 90. lol  

[v-stephen-msft · Accepted solution]

Hi @Gumberculeez ,

Well, then you need to create a new measure based on your measure in the card and these filters in the card too.

For example, below card has a measure and a filter applied.

Create a new measure based on them.

Measure 2 = CALCULATE([Measure],FILTER('Table',[Index] in {1,2,3,4,5,6}))

Of course, in order to cope with more complex cases, it may be necessary to add the ALL function or the ALLSELECTED function.

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.           

[v-stephen-msft]

Hi @Gumberculeez ,

DIVIDE function is available in DirectQuery. If you want to divide the value in the card visual by 90, you can create a new measure like this:

New Measure = DIVIDE([Field in card visual], 90)

If the field in your card visual is a measure, refer directly, and if it is a column, reference it with the SUM function, MAX function, or MIN function.

New Measure = DIVIDE(SUM('TABLE'[COLUMN in card visual] ), 90)

Tutorial: Create your own measures in Power BI Desktop - Power BI | Microsoft Learn

DIVIDE function (DAX) - DAX | Microsoft Learn

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.