Need Solution for LOD caluclation

Version 1

    HI All,

         I need solution for Below case

    case: I need count of each Male and Female Fraud's happen in each country,

          I tried solution with LOD concept but i get Total count for each state wise or total count of frauds for each gender but i need solution in single calculation

    My solution: CASE [Gender] WHEN [Gender]='Male' THEN { FIXED[country]:SUM(IF([Fraud]='Y')THEN 1 ELSE 0 END )} WHEN [Gender]='Female' THEN { FIXED[Country]:SUM(IF([Fraud]='Y')THEN 1 ELSE 0 END )} END

     

    for my solution i am getting error "Expected type string, found Boolean. Comparsssion in "CASE" expression must be string"

     

     

    Here: { FIXED[Incident State]:SUM(IF([Fraud Reported]='Y')THEN 1 ELSE 0 END )}     gives count of frauds for each country

    Example Data: I have a data like this

    CountryGenderFraud
    USAMaleYes
    USAFemaleYes
    USAMaleNo
    USAMaleYes
    USAFemaleNo
    INDMaleYes
    INDMaleNo
    INDFemaleNo
    INDFemaleNo