Forum Discussion

Janet_PHQ's avatar
Janet_PHQ
Icon for Helper I rankHelper 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's avatar
    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's avatar
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

Janet_PHQ's avatar
Janet_PHQ
Icon for Helper I rankHelper I
9 years ago

Hello XIaoxin ,

 

Thanks for your reply! I will try it soon :)

 

Each event only has a single category so there is no need to worry about that. 

 

Cheers,

Janet