powerbi

[shubham345]

I have net net revenue ,net engagement margin ,client name ,em%(em/nr) by each fiscal year.I need to calculate client count for 80% of em?

[shubham345]

	client count	nr	em%	em	hour
eM 100% OF Total	2433	$568	43%	168m	2993k
EM 80% of total	2344	$567	34%	168m	3425k

[v-xuding-msft]

Hi @shubham345 ,

Please try like this:

Measure = COUNTROWS(FILTER('Table',[em%]>=0.8))

Measure = COUNTROWS(FILTER(ALLEXCEPT('Table','Table'[fiscal year]),[em%]>=0.8))

If they don't work, please share some sample data and expected output. We will understand clearly.

[Pragati11]

Hi @shubham345 ,

First thing your 2-liners are not helping at all in understanding your query.

Refer following blog on how to get your query answered here:

https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

Thanks,

Pragati

[shubham345]

Hi @Pragati11  fiscal year is in slicer

[Pragati11]

Hi @shubham345 ,

I am still not clear on your question. Your sample data seems to be unclear.

Try sharing sample in a clear way. Headers and rows look mixed up.

Thanks,

Pragati

[shubham345]

Hi @Pragati11 ,

I need to calculate client count,EM,Em% , net revenue for the "80% Em of total"(for top 80%). I have net Engagement margin and client name in the coloumns