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.           

Anonymous's avatar
Anonymous
Not applicable
3 years ago

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.