Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to Solution.
Hi @mohuas
Try this MEASURE
Sales% = DIVIDE ( CALCULATE ( SUM ( TableName[Value] ), TableName[Attribute] = "Sales" ), CALCULATE ( SUM ( TableName[Value] ), TableName[Attribute] = "Opportunity" ) )
Hi @mohuas
Try this MEASURE
Sales% = DIVIDE ( CALCULATE ( SUM ( TableName[Value] ), TableName[Attribute] = "Sales" ), CALCULATE ( SUM ( TableName[Value] ), TableName[Attribute] = "Opportunity" ) )
@Zubair_Muhammad Thank You so much for the help. The provided solution worked. 🙂
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
94 | |
80 | |
67 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |