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
    Dangar332
    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.

Dangar332's avatar
Dangar332
Resident Rockstar
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.

  • Sri_phani's avatar
    Sri_phani
    Helper III
    2 years ago

    Hi Dangar332 . 

     

    Thank you for responding! 

    I only have employee name and Date as slicers. But the objective is to identify the rank amount particular LOB ( team). Example : total 200 employees are there. I don't need rank among 200 employees. I need rank among team of 50 employees. For that I tried above approach. Does your measure, help me with my problem?

    • Dangar332's avatar
      Dangar332
      Resident Rockstar
      2 years ago

      Hi, Sri_phani 

      Please try my updated Rankx measure; it might fix your issue.

       

      Best Regards,
      Dangar

       

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

      • Sri_phani's avatar
        Sri_phani
        Helper III
        2 years ago

        Hi Dangar332  This worked like magic. You don't know how much relieved I am. I worked like crazy on this logic since last 2 days. Thank you very much. Have a great day!