powerbi

Question

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?

pragati11 · Answer

Hi&nbsp;shubham345&nbsp;,&nbsp;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&nbsp;Thanks,Pragati

v-xuding-msft · Answer

Hi&nbsp;shubham345&nbsp;,
&nbsp;
Please try like this:
Measure = COUNTROWS(FILTER('Table',[em%]&gt;=0.8))Measure = COUNTROWS(FILTER(ALLEXCEPT('Table','Table'[fiscal year]),[em%]&gt;=0.8))
&nbsp;
If they don't work, please share some sample data and expected output. We will understand clearly.
&nbsp;

shubham345 · Answer

&nbsp;&nbsp;client countnr&nbsp;em%em&nbsp;houreM 100% OF Total2433$56843%168m2993kEM 80% of total&nbsp;2344$56734%168m3425k&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;

shubham345 · Answer

Hi&nbsp;Pragati11&nbsp; fiscal year is in slicer

pragati11 · Answer

Hi&nbsp;shubham345&nbsp;,&nbsp;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.&nbsp;Thanks,Pragati

Forum Discussion

powerbi

6 Replies

Related content

POWERBI Subscription

PowerBI Workspaces

iframe powerbi

PowerBI Relationships

PowerBi Co-Pilot

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