Forum Discussion

Gumberculeez's avatar
Gumberculeez
Icon for Helper II rankHelper II
3 years ago
Solved

Divide a card output?

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...
Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    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.           

Gumberculeez's avatar
Gumberculeez
Icon for Helper II rankHelper II
3 years ago

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  

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    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.