Distinct count of Column below 15 .5 percentage of calculated measure

[SAPpowerbi]

Hello Team ,

I have query , where i need distinct count of Distributor Name where Revenue is less than 15.5%

below is  some dummy Source data and ouput .

 Source Data 

Region	Distrubutor Name	Revenue % (Calculated measure %)
UK	ABEnterprice	20.5%
UK	ACG	10.5%
UK	DAM	13.5%
UK	WAP	25.5%
Vaitnam	AB	21.2%
Vaitnam	BD	22.2%
Vaitnam	QZ	12.3%
Vaitnam	WW	12.1%
Austreliya	AA	18.2%
Austerliya	BB	16.2%

I want 2 Output one is for Graph and another is for Table .

1 - Graph Output (Need  DIstinct count of distributor name where revenue below 15.5%) also there is no data for austreliya  still we need to show 0 as count in graph .

X -axis (Region Name)	Y -axis (Distrubutor name distinct count)
UK	2
Vaitnam	2
Austreliya	0

2 - Table output -(Need Revenue below 15.5%)

Region	Distributor Name	Revenue %	Distiinct count
UK	ACG	10.5%	1
UK	DAM	13.5%	1
Vaitnam	QZ	12.3%	1
Vaitnam	WW	12.1%	1

Thank you in advance , please help me to resolve this issue.

[Ashish_Mathur]

Hi,

For the first solution, try this measure

Measure1 = countrows(filter(values(data[distributor name]),[Revenue %]<0.155))

Drag Region and Measure1 to your visual.

Does this work?

[SAPpowerbi · Accepted solution]

Yes it's perfect working ,Thank you so much 😊 

[Ashish_Mathur]

You are welcome.  If my reply helped, please mark it as Answer.

[TomMartens]

Hey @SAPpowerbi ,

can you please create a Power BI desktop file that contains the sample data using the manual input method, but still reflects your data model, including the measure. Upload the pbix to onedrive or dropbox and share the link. if you are using Excel to create the sample data, share the xlsx as well.

Regards,

Tom