Forum Discussion

Sri_phani's avatar
Sri_phani
Helper III
2 years ago
Solved

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...
  • Dangar332's avatar
    2 years ago

    Hi, Sri_phani 

    As i understood your problem you have Three slicer in page
    1.  Employee Name  

    2. site+LOB

    3. Dates 


    Try below measure 

    create Measure for attain_measure

     

    attain_measure=
    var Numerator = SUM('Metric Table'[Resolve Numerator])
    var Denominator = SUM('Metric Table'[Resolve Denominator]))
    return
    (divide(Numerator,Denominator))/0.60

     

    Create RankX_measure for your Card visuals 
    use below measure for your Card visuals

     

    RankX_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,
    Dangar

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.