specific value

[Anonymous]

Name	Status
Mike	Pass
John	Fail
Nick	Fail
Katy	Pass

I need seperate calcualtion for each Name for their respective status so i can use these calcualtion in an visual.
so for example "Mike Calcualtion" is created & when i put this calculation on a Card, Card should only show "Pass" on it.
Please help how can i craete such calculation !

[v-jingzhang · Accepted solution]

Hi @Anonymous 

If you want a specific measure to get the result, you can use

Mike Calculation = CALCULATE ( SELECTEDVALUE ( 'Tablename'[Status] ), 'Tablename'[Name] = "Mike" )

If you have a slicer or a filter to select a Name, you can use only SELECTEDVALUE like

Mike Calculation = SELECTEDVALUE ( 'Tablename'[Status] )

Hope this helps. 

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.

[Tahreem24]

@Anonymous, With the help of visual level filter you can apply seperate user name condition: