I have the below Model.
Table 1: (Sheet 1)
Sheet 1 Table
Table 2: (Score)
I have the following measures to display the visual below.
Go to Solution.
Hi @Vishnoo ,
You can try to use following measure if it suitable for your scenario:
VAR summary =
"CYTS", CALCULATE (
DISTINCTCOUNT ( Sheet1[Candidate ID] ),
ALLSELECTED ( Sheet1 ),
Sheet1[Academic Year] = EARLIER ( Sheet1[Academic Year] )
&& Sheet1[Score] > 120
"SxCYTS", [Score] * [CYTS]
[School Code] IN ALLSELECTED ( Sheet1[School Code] )
AVERAGEX ( summary, [SxCYTS] )
If above not help, please share some sample data for test.
Engage and empower students with Power BI!
Continue your learning in our online communities.
Travel to Melbourne and network with thousands of peers!
Check out what's new in the Power BI Community!