Sum of % from two visuals with filters

[Varshi288]

Hi  Everyone,

I have two visuals where I calculate the Percentage for Standard products(Excl CSM) and Customer Specific Products (CSM). There is a filter on visuals i.e  CSM code = Blank for Excl CSM and CSM Code = X for CSM. I need to show combined Percentages in another visual. any help.

TP incr % CSM = DIVIDE([TP incr CSM],[Cov TP CSM]-[TP incr CSM])    

TP incr % Vs PrY = DIVIDE([TP incr PrY],[Cov TP]-[TP incr PrY])

I was trying with If statement. but couldn't get it. Any help.

[Varshi288]

Hi  @MFelix ,

I exactly used the same logic before you replied. Thanks

[MFelix · Accepted solution]

Hi @Varshi288 ,

In this case you need to add the filtering on the calculation of the new measure something similar to this:

CSM + CSM EXCLUDE =
CALCULATE([TP incr % CSM] , Table[CSM Code] = X) + 
CALCULATE([TP incr % Vs PrY], CSM code = Blank()) 

Not sure if I selected the correct measures for the filters, but the sintax is this one.