Forum Discussion

mohuas's avatar
mohuas
New Member
8 years ago
Solved

Ratio calculation from same column

The below screenshot is an example of sorted data where we have city, month, the numerator (Sales), the denominator (Opportunity) and values. Now, we want to calculate the Sales % i.e., Sales / Oppor...
  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    8 years ago

    Hi mohuas

     

    Try this MEASURE

     

    Sales% =
DIVIDE (
    CALCULATE ( SUM ( TableName[Value] ), TableName[Attribute] = "Sales" ),
    CALCULATE ( SUM ( TableName[Value] ), TableName[Attribute] = "Opportunity" )
)
Zubair_Muhammad's avatar
Zubair_Muhammad
Icon for Community Champion rankCommunity Champion
8 years ago

Hi mohuas

 

Try this MEASURE

 

Sales% =
DIVIDE (
    CALCULATE ( SUM ( TableName[Value] ), TableName[Attribute] = "Sales" ),
    CALCULATE ( SUM ( TableName[Value] ), TableName[Attribute] = "Opportunity" )
)
mohuas's avatar
mohuas
New Member
8 years ago

Zubair_Muhammad Thank You so much for the help. The provided solution worked. :)