Ratio calculation from same column

[mohuas]

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 / Opportunity – city wise + month wise, and create a dashboard for the same. I am unable to do so in Power BI, please help.

[Zubair_Muhammad · Accepted solution]

Hi @mohuas

Try this MEASURE

Sales% =
DIVIDE (
    CALCULATE ( SUM ( TableName[Value] ), TableName[Attribute] = "Sales" ),
    CALCULATE ( SUM ( TableName[Value] ), TableName[Attribute] = "Opportunity" )
)

[mohuas]

@Zubair_Muhammad Thank You so much for the help. The provided solution worked. 🙂