Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 !
Solved! Go to 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.
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.
@Anonymous, With the help of visual level filter you can apply seperate user name condition:
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
93 | |
84 | |
66 |