Return baseline value for a selected indiviual

[CDixon]

Hi All,

I have a table which shows students scores for each subject.  Also on this table is a baseline  which is the same for all subjects.  I would like to display the baseline in a card visiualisation for that person when therir name is selected form a slicer.

Is this possible?

Kind regards

C

[CDixon · Accepted solution]

Thank you thats whats I understood should be happening and why i rasied it on here.  The issue was to do with the new query a merge created.  If I merge in the existing query it worked fine. Thanks again for your help.

[djurecicK2]

In that case, just create a card visual and put the baseline field in the "Fields" section of the visual. The value will change automatically when the name changes.

Please consider accepting as solution if this has answered the question.

[CDixon]

Yes your correct 5 if a 6 see if b

[djurecicK2]

@CDixon You want 5 to appear if name a is selected, but 6 if b is selected, right? or 5 no matter which name is selected?

[CDixon]

Thank you for your help and I have provided a table below.  So ideally if I select the name a i want 5 to appear in a card.

name	subject	grade	baseline
a	fr	2	5
a	ma	3	5
a	ar	4	5
b	fr	3	6
b	ma	3	6
b	ar	5	6

Hope that helps.

[djurecicK2]

Or Edit Interactions and turn off interaction between the card visual and the slicer.

[amitchandak]

@CDixon , A measure like

measure  =

calculate(Sum(Table[Score]),filter(Table, Table[subject] = "Baseline"))

If this does not help
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.