Forum Discussion
Calculation using 2 data cards %
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, 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.
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
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.
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