Forum Discussion

socksinbox's avatar
socksinbox
Helper I
7 years ago

Adding Variance measure between current & previous month in a matrix visual

Hi,

 

I have a matrix visual which shows categories on rows and months on columns. 
Each cell shows the count of the incident for a particular category in a given month.

 

Now i have to add another column for variance as shown below? How can I do this in PowerBI

 

 

cheers,

 

Need Help

1 Reply

  • Ani1991's avatar
    Ani1991
    Resolver III
    7 years ago

    Hi socksinbox ,

    You can try something like below.

    Create a measure like one below,

     

    Variance =
    var variable = CALCULATE(SUM(Categories[Value]),Categories[Month]="Jun")-CALCULATE(SUM(Categories[Value]),Categories[Month]="May")
    RETURN
    IF(ISBLANK(variable),0,variable)
     
    Remember, I have hardcoded the value here just to explain how this can be achieved because I am not aware whether the variance is calculated with reference to any slicer selection. That been the case then you need to just replace the hardcoded value with the SELECTEDVALUE using the SELECTEDVALUE function.
     
    Thanks,
    Ani