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.
Hi friends,
I have some conversion percentages for some products. All I want to do is calculate using a measure, the forecasted revenue if the conversion % is multiplied by the pipeline.
Lets say this is the data:
Prod A - Conversion % = 60
Prod B- Conversion % = 50
Prod C - Conversion %= 30
I have a slicer on the Product Type so my projections should change based on the product type selected. The problem I am having is that I am multiplying the pipeline with
in the measure and the aggregator is incorrect for my purpose. however I am not sure how I can just multiply with the % without using it. Can any one of you help me understand? Thanks.
Regards,
Lakshmi
Solved! Go to Solution.
HI @lsuresh89 ,
It sounds like a weighted aggeration calculatiion requirement.
You can try to write measure with summarize function and switch function to manually calculate with weighted rate with aggregated results.
If you confused about coding formula, can you please share some sample data for test?
Regards,
Xiaoxin Sheng
HI @lsuresh89 ,
It sounds like a weighted aggeration calculatiion requirement.
You can try to write measure with summarize function and switch function to manually calculate with weighted rate with aggregated results.
If you confused about coding formula, can you please share some sample data for test?
Regards,
Xiaoxin Sheng
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 |
---|---|
112 | |
100 | |
76 | |
74 | |
49 |
User | Count |
---|---|
146 | |
108 | |
106 | |
90 | |
62 |