Forum Discussion

harshaSampath81's avatar
harshaSampath81
Helper II
8 years ago

Calculation in Metrix

here I have some example, I am using Power BI Metrix as above, so I want to subtract  expenses total(2382) from Income Total(16500) and show as Gross profit with value (14120) above the Asset l...
Need Help
Anonymous's avatar
Anonymous
Not applicable
8 years ago

Hi harshaSampath81,

 

You can try to use if statement to check current content to force replace display result based on specific calculate formula.

Sample formula:

Measure =
VAR currCate =
    SELECTEDVALUE ( Table[Categroy] )
VAR currDesc =
    SELECTEDVALUE ( Table[Desc] )
RETURN
    IF (
        currCate = "Income"
            && currDesc = "Cash In Bank",
        CALCULATE (
            SUM ( Table[Amount] ),
            FILTER ( ALLSELECTED ( Table ), Table[Categroy] = "Income" )
        )
            - CALCULATE (
                SUM ( Table[Amount] ),
                FILTER ( ALLSELECTED ( Table ), Table[Categroy] = "Expense" )
            ),
        SUM ( Table[Amount] )
    )

 

Notice: these replace value not summarize with original records.

 

Regards,

Xiaoxin Sheng