Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Subtotal not showing in visual

Hi,

 

I used this DAX trying to calculate subtotals

 

Segment3 =
VAR CurrentItem = SELECTEDVALUE('Net Opex'[PnL.Segment3])

RETURN
SWITCH(TRUE(),
CurrentItem = "Gross Margin", DIVIDE([Gross Margin], 1000, 0),
CurrentItem = "Gross Opex before Recharges (Op Exps)", DIVIDE( [Gross Opex before Recharges (Op Exps)],1000,0),
CurrentItem = "Net Opex", DIVIDE( [net opex1],1000,0),
CurrentItem = "EBITDA", DIVIDE( [EBITDA],1000,0),
CurrentItem = "EBIT", DIVIDE([EBIT],1000,0),
    CALCULATE([Total Amount],
     FILTER('Net Opex','Net Opex'[PnL.Segment3] = CurrentItem)
    )
       
)
File:
PnL 2 - Power BI
Unfortunately they either are not showing or are showing the wrong amount.
 

 

 
 
Need Help

2 Replies

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    3 years ago

    Anonymous , Try like

    Segment3 =
    VAR CurrentItem = SELECTEDVALUE('Net Opex'[PnL.Segment3])
    sumx(values([PnL.Segment3]) ,calculate (
    SWITCH(TRUE(),
    CurrentItem = "Gross Margin", DIVIDE([Gross Margin], 1000, 0),
    CurrentItem = "Gross Opex before Recharges (Op Exps)", DIVIDE( [Gross Opex before Recharges (Op Exps)],1000,0),
    CurrentItem = "Net Opex", DIVIDE( [net opex1],1000,0),
    CurrentItem = "EBITDA", DIVIDE( [EBITDA],1000,0),
    CurrentItem = "EBIT", DIVIDE([EBIT],1000,0),
    CALCULATE([Total Amount],
    FILTER('Net Opex','Net Opex'[PnL.Segment3] = CurrentItem)
    )

    )))

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Thank you .

    Sorry, but I don't think replacing RETURN with 

     

    sumx(values([PnL.Segment3]) ,calculate (

     

    gives me a correct dax