Forum Discussion
Sri_phani
2 years agoHelper III
Cannot Identify the table that contain column
Hi team, Kindly help me with this. I executed this table measure in the DAX query view. The problem with this is, that I am unable to use this in Measure and show value in the card. the obj...
- 2 years ago
Hi, Sri_phani
As i understood your problem you have Three slicer in page
1. Employee Name2. site+LOB
3. Dates
Try below measure
create Measure for attain_measureattain_measure= var Numerator = SUM('Metric Table'[Resolve Numerator]) var Denominator = SUM('Metric Table'[Resolve Denominator])) return (divide(Numerator,Denominator))/0.60Create RankX_measure for your Card visuals
use below measure for your Card visualsRankX_measure = var Table_ = addcolumn( filter( all('Metric Table'[Employee Name], 'Metric Table'[Site + LOB] ), 'Metric Table'[Site + LOB] = "Hyderabad - Rider"), "attain",[attain_measure]) return rankx(Table_,[attain_measure],,desc,dense)Best Regards,
DangarIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.