Using power BI in school - support

Hi  Anonymous ,

I created the data:

Here are the steps you can follow：

Show students' learning progress throughout the year：

1. Create measure.

Grade =
SUMX(FILTER('Table',[comment]<>"Eoy target"&&[comment]<>"Baseline"),[garde])

target =
IF(MAX('Table'[comment])="Eoy Target"||MAX('Table'[comment])="Baseline",BLANK(),
SUMX(FILTER(ALL('Table'),[comment]="Eoy target"&&[Subject]=SELECTEDVALUE('Table'[Subject])&&[Student]=SELECTEDVALUE('Table'[Student])),[garde]))

Baseline =
IF(MAX('Table'[comment])="Eoy Target"||MAX('Table'[comment])="Baseline",BLANK(),
SUMX(FILTER(ALL('Table'),[comment]="Baseline"&&[Subject]=SELECTEDVALUE('Table'[Subject])&&[Student]=SELECTEDVALUE('Table'[Student])),[garde]))

2. Using [Student] and [Subject] as slicers, open the Line and clustered column chart, place [comment] in the Shared axis, [Grade] in the Column values, and [target] and [Baseline] in the Line values.

3. Result:

Through the slicer, only those subjects that meet and exceed the target or subjects that do not meet the target are displayed:

1. Use Enter data to enter a table as a slicer.

2. Create measure.

Flag =
SWITCH(
    SELECTEDVALUE('Table (2)'[Value]),
    "Over target",
    IF([Grade]>=[target],1,0),
    "Not over target",
    IF([Grade]<[target],1,0),
    1)

3. Use [Value] in Table(2) as a slicer, and put [Flag] in Filter, set is = 1, apply filter.

4. Result:

Choose "Not over target" to display data that does not meet the target:

Choose "Over target" to display the data that meets the target:

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.