Forum Discussion

RonLieuw's avatar
RonLieuw
Icon for Helper I rankHelper I
8 years ago
Solved

Calculated item alternative

  I need to calculate a Sex ratio ([male/female]*100) for every year. I read on the forum to make 3 measure e.g F, M and use sexratio=M/F. I am having problems calculating the measures F and M, wh...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    8 years ago

    Hi,

     

    Do not drag Sex to the column area section.  Just drag years to the row area section and then write the 3 measures that i shared with you in my earlier post.

Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
8 years ago

Hi,

 

If you want to get your desired result on an unpivoted dataset, try these measures:

 

Males = CALCULATE(SUM(Data[Aantal]),Data[Sex]="Male")

Females = CALCULATE(SUM(Data[Aantal]),Data[Sex]="Female")

Sex ratio (%) = [Males]/[Females]

 

Hope this helps.

RonLieuw's avatar
RonLieuw
Icon for Helper I rankHelper I
8 years ago

HI , thanks for your input. This certainly helps!.

Can I conclude that you cannot caculate the sex ratio on a pivotted list?

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Icon for Super User rankSuper User
    8 years ago

    Hi,

     

    v-piga-msft has already shared that solution with you.

    • RonLieuw's avatar
      RonLieuw
      Icon for Helper I rankHelper I
      8 years ago

      Asish, v-piga-msft solution was for an unpivotted file with columns for male and female!

      • Ashish_Mathur's avatar
        Ashish_Mathur
        Icon for Super User rankSuper User
        8 years ago

        Hi,

         

        In which case, i am not clear about the terminology you are using.  Please show the dataset and the expected result.