DAX calculation ignoring one column

[patilpoonam21]

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!

Index	emp_Id	Participant_id	measure	Annual Att	Measure_weight
1	11	111	booking	0.6	0.4
2	12	123	revenue	0.3	0.3
3	12	123	revenue	0.3	0.3
4	14	153	booking	1.2	0.8
5	14	32	Opportunities	1.4	0.7
6	15	44	booking	1.2	0.5
7	15	44	booking	1.2	0.5

[v-tianyich-msft]

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.

[ryan_mayu]

what do you mean ignore the last column?

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

[patilpoonam21]

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!

Index	emp_Id	Participant_id	measure	Annual Att
1	11	111	booking	0.6
2	12	123	revenue	0.6
3	14	153	booking	1.2
4	14	32	opportunities	1.4
5	15	44	booking	2.4