Show percentage based on Month

[magji]

Hello, I hope you can help me.

In this visual i have to show the percentage of Balance (with some conditions) every month.
The only option i see is to show the balance as Percent of Grand Total, but i need to show it as:

Ex: Percentage at May = Balance (with conditions)in May /Total balance in May.

[amitchandak · Accepted solution]

@magji , Try like

divide(sumx(Filter(Table[A]="X"),[Balanace]),sumx(All(Table[A]),[Balanace]))