Company VS Cohort Analysis with two Slicers

[ralba80]

Hi All, 

I am new to the forum and have a basic DAX knowledge. I am trying to build a Company vs Peer Group feature in one dashboard but have not been able to do it. Maybe is easier than I think and I might be approaching the problem in a difficult way. Here is my model:

The idea is that Company Slicer (single selection) affects only column Averag Production and Cohort Slicer (Multiple Selection) affects Column Production Cohort AVG 

I will be gratefull if you can provide guidance on how to approach this feature @amitchandak @Jihwan_Kim @selimovd

Best Regards,

ralba80

[amitchandak · Accepted solution]

@ralba80 , In the Production Cohort AVG

use

calculate(sum(TFact[Prodcution]), filter(all(TdimCompany), TdimCompany[company] in allselected(TdimCohortCompany[company])))

something very similar I dicssued for date

https://www.youtube.com/watch?v=44fGGmg9fHI