Forum Discussion
specific value
| 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 !
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.
2 Replies
Anonymous, With the help of visual level filter you can apply seperate user name condition:
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.
