Forum Discussion

Helper I

9 years ago

Solved

Get global coverage based on conditions

Hello everyone, I would like to seek some advice regarding the following question please. I have 3 tables: 1 is a big fat table for events of different categories across the globe. The 2nd table ...

Need Help

Anonymous

9 years ago

HI Janet_PHQ,

Perhaps you can try to use below formulas to calculate the percent festivals and expos if they suitable for your requirement.

count of festivals and expos %(exclude US)=
DIVIDE(CALCULATE(Count([Count]),FILTER(ALL(Table1),AND([Category]="festivals",[Category]="expos")&&[CountryCode]<>"US"))
,COUNTAX(ALL(Table1),[Category]),0)

Count of festivals or expos %(exclude US)= 
DIVIDE(CALCULATE(Count([Count]),FILTER(ALL(Table1),OR([Category]="festivals",[Category]="expos")&&[CountryCode]<>"US"))
,COUNTAX(ALL(Table1),[Category]),0)

BTW, I found your category column only store single category each row, how did you calculate the count of event who contains multiple categories?

Regards,

XIaoxin Sheng

Anonymous

Not applicable

9 years ago

HI Janet_PHQ,

Perhaps you can try to use below formulas to calculate the percent festivals and expos if they suitable for your requirement.

count of festivals and expos %(exclude US)=
DIVIDE(CALCULATE(Count([Count]),FILTER(ALL(Table1),AND([Category]="festivals",[Category]="expos")&&[CountryCode]<>"US"))
,COUNTAX(ALL(Table1),[Category]),0)

Count of festivals or expos %(exclude US)= 
DIVIDE(CALCULATE(Count([Count]),FILTER(ALL(Table1),OR([Category]="festivals",[Category]="expos")&&[CountryCode]<>"US"))
,COUNTAX(ALL(Table1),[Category]),0)

BTW, I found your category column only store single category each row, how did you calculate the count of event who contains multiple categories?

Regards,

XIaoxin Sheng