Forum Discussion

UKNSI-Powerbi's avatar
UKNSI-Powerbi
Frequent Visitor
4 years ago

Visual Matrix - add new calculated column

Hi,

 

New on PowerBi, I need some help how to calculate a column on a visual matrix.

 

On this example the calculation formula should be SumQty/SumSTock*21 - ((205+940+640+1200+340)/85)*21 and result 0,53 

 

 

Thanks in advance

 

 

 

Need Help

1 Reply

  • v-kkf-msft's avatar
    v-kkf-msft
    Community Support
    4 years ago

    Hi UKNSI-Powerbi ,

     

    Suppose you have the following example data, then try the following measure. It will change the way the column total is calculated.

     

    TotalValue = 
IF (
    ISFILTERED ( 'Table'[Date] ),
    SUM ( 'Table'[Values] ),
    DIVIDE ( SUM ( 'Table'[Qty] ), SUM ( 'Table'[Stock] ) ) * 21
        - SUM ( 'Table'[Values] ) / 85 * 21
)

     

    If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
    Best Regards,
    Winniz
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.