Forum Discussion

patilpoonam21's avatar
patilpoonam21
Icon for Helper I rankHelper I
2 years ago

DAX calculation ignoring one column

Hi,

In the below table, I have added 'Index' column which is incremented by 1.

Currently I am calculating number of rows using below formula:

Greater_than_100_Count_Annual = CALCULATE(Count(Table1[Index]), FILTER(Table1, [Annual Att]>=1))
I want get the count of Index by ignoring last column i.e 'Measure_weight'.
Is there any way to achiee that using DAX? 
Thanks in advance!
Indexemp_IdParticipant_idmeasureAnnual AttMeasure_weight
111111booking0.60.4
212123revenue0.30.3
312123revenue0.30.3
414153booking1.20.8
51432Opportunities1.40.7
61544booking1.20.5
71544booking1.20.5
Need Help

3 Replies

  • ryan_mayu's avatar
    ryan_mayu
    Icon for Super User rankSuper User
    2 years ago

    what do you mean ignore the last column?

    what's the expected output based on the sample data you provided?

    • patilpoonam21's avatar
      patilpoonam21
      Icon for Helper I rankHelper I
      2 years ago

      The expected output should be based on below table:

      Count of index whose Annual Att>1. Is there any wany to calculate that in the DAX without creating summarized table?

      Currently, I have created below summarized table and created relationship between the above main table and below summarized table based on emp_id, participant_id and measure column.

      Thank you!

       

      Indexemp_IdParticipant_idmeasureAnnual Att
      111111booking0.6
      212123revenue0.6
      314153booking1.2
      41432opportunities1.4
      51544booking2.4
  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi patilpoonam21 ,

     

    Not quite sure what you need, I'm presuming you need to return the value of index.

    Your measure(It gives the count):

    You can try below:

     

    Please feel free to correct me and provide more information if I have misunderstood you!

     

    Hope it helps!

     

    Best regards,
    Community Support Team_ Scott Chang

     

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