Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi, Thank you in advance for helping out for the below.
I have a results by year and I would like to calculate extrapolated rate for the current year using previous years average.
Data is as follows:
I have a 2 data cards A is at 62% and B is at 57%, my objective is to calculate C (A/B = 92%). These are calculated using year filter.
I tried doing C=divide(B,A), its giving the results of 100% as I have not filtered for any feilds.
Please help me to arrive C,
Solved! Go to Solution.
Hi,
These measures work
Average win % from 2017 - 2021 = AVERAGEX(filter(summarize(VALUES('Table'[Year]),'Table'[Year],"ABCD",[Sum_Win],"EFGH",[Sum_Opps]),'Table'[Year]>=2017&&'Table'[Year]<=2021),DIVIDE([ABCD],[EFGH]))
Win % in 2022 = AVERAGEX(filter(summarize(VALUES('Table'[Year]),'Table'[Year],"ABCD",[Sum_Win],"EFGH",[Sum_Opps]),'Table'[Year]=2022),DIVIDE([ABCD],[EFGH]))
Measure = DIVIDE([Win % in 2022],[Average win % from 2017 - 2021])
Hope this helps.
I have helped you enough on this. I rewrote all formulas in the file which i shared with you today. Looks like tyou have not even looked at that file. Someone else will help you
Hi,
Share the download link of your PBI file. Ensure that you already have your measures for A and B there.
Hi,
These measures work
Average win % from 2017 - 2021 = AVERAGEX(filter(summarize(VALUES('Table'[Year]),'Table'[Year],"ABCD",[Sum_Win],"EFGH",[Sum_Opps]),'Table'[Year]>=2017&&'Table'[Year]<=2021),DIVIDE([ABCD],[EFGH]))
Win % in 2022 = AVERAGEX(filter(summarize(VALUES('Table'[Year]),'Table'[Year],"ABCD",[Sum_Win],"EFGH",[Sum_Opps]),'Table'[Year]=2022),DIVIDE([ABCD],[EFGH]))
Measure = DIVIDE([Win % in 2022],[Average win % from 2017 - 2021])
Hope this helps.
Dear Ashish, Thank you for the previous measures and it is useful. Now, again thank you in advance for helping me out with another measure.
With the same example below, I would like to get the extrapolated rate i.e.,
Win % in 2022(57.01%)*Measure (91.95%) = 52.42%
You are welcome.
Just multiply the 2 measures.
Hi, thank you for your reply. I tried multiplying the 2 measures but it is not giving the right results.
I think this is not right because of 2 different quarter selections.
Win % in 2022 = AVERAGEX(filter(summarize(VALUES('Table'[Year]),'Table'[Year],"ABCD",[Sum_Win],"EFGH",[Sum_Opps]),'Table'[Year]=2022),DIVIDE([ABCD],[EFGH]))
Measure = DIVIDE([Win % in 2022],[Average win % from 2017 - 2021])
Now, I have to multiply Measure*Win % in 2022.. this is not giving the right calculations
Request you to have a look and help me.
.pbix file link is here https://drive.google.com/file/d/1UqlJiogfwjl_zTesUstYGOK2cgcGX0xY/view?usp=sharing
I get the correct answer - see Measure 2. Download the PBI file from here.
Thank you, Ashish. Thank you so much for your continuous help on this. Actually, my requirement is to calculate win rates and extrapolated rates for each quarter and check for the current year's quarter. I am able to do all the calculations with your support other than the multiplication of current year quarter win rate with the extrapolated win rate of the previous quarter. Requirement to calculate D*C = 68.9%
A.
B.
C.
D.
I still do not know what you want . Download the revised file from here.
Hope this helps.
Sorry for the confusion.
Please find the .pbix file (Ref Table (2)) and request you to help. Thank you as always.
https://drive.google.com/file/d/1F5z4vESS1uLquMzqi6Pr591lu3aQYjag/view?usp=sharing
I have helped you enough on this. I rewrote all formulas in the file which i shared with you today. Looks like tyou have not even looked at that file. Someone else will help you
Kindly support on the above query. I am thankful in advance for the support
User | Count |
---|---|
97 | |
87 | |
78 | |
74 | |
69 |
User | Count |
---|---|
113 | |
105 | |
84 | |
65 | |
64 |