Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Learn from the best! Meet the four finalists headed to the FINALS of the Power BI Dataviz World Championships! Register now

Reply
Anonymous
Not applicable

Count of percentage column > 50 values

‎02-06-2022 11:36 PM

Hi,

please help to get the count values from percentage > 50%.

I have partner column and dax measure of percentage column.

 

please check the screenshot and suggest.

vs_7_2-1644218429907.png

 

 

 

Labels:
Message 1 of 7
1,519 Views
0
6 REPLIES 6
V-lianl-msft
Community Support
Community Support

‎02-09-2022 07:16 PM

Hi @Anonymous ,

 

Please refer to the sample .pbix.

If the problem persists, please provide a sample pbix after deleting sensitive data.

https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216 


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

test.pbix
Message 5 of 7
1,447 Views
0
Anonymous
Not applicable
In response to V-lianl-msft

‎02-10-2022 09:49 PM

Hi @V-lianl-msft ,

Spoiler
DateC Month NumC YearF YearQuarterDisplay YearMonth NamePARTNERCODENETVALUEUnitUnit ValuesSort
01-05-2019520192019Q12019-2020JanuaryMY05I2348547042.44CR100000003
02-05-2019520192019Q12019-2020JanuaryMR05I2191051750.32Lac1000002
03-05-2019520192019Q12019-2020JanuaryMR05I2191028525.18K10001
04-05-2019520192019Q12019-2020January30APP0410021070.3   
05-05-2019520192019Q12019-2020January30APP0410030000   
06-05-2019520192019Q12019-2020JanuaryFI05A19162900   
07-05-2019520192019Q12019-2020JanuaryFI05A1916262819.11   
08-05-2019520192019Q12019-2020JanuaryFI05A1916250391.09   
09-05-2019520192019Q12019-2020January30ANA0410088000   
10-05-2019520192019Q12019-2020JanuaryRETAIL41002098.36   
01-07-2019720192019Q22019-2020January30APP0410020800   
02-07-2019720192019Q22019-2020January30APP0410022500   
03-07-2019720192019Q22019-2020January30APP041006250   
04-07-2019720192019Q22019-2020January30APP04100557839.98   
05-07-2019720192019Q22019-2020January30APP0410089640   
06-07-2019720192019Q22019-2020January30APP041001430047.94   
07-07-2019720192019Q22019-2020January30APP04100480791.98   
08-07-2019720192019Q22019-2020January30APP0410088375   
09-07-2019720192019Q22019-2020January30LED04100156000   
10-07-2019720192019Q22019-2020JanuarySYS05I67111671597.54   
01-10-20191020192019Q32019-2020JanuarySYS05I6711815413.44   
02-10-20191020192019Q32019-2020JanuarySYS05I67112832489.18   
03-10-20191020192019Q32019-2020JanuarySYS05I671138610   
04-10-20191020192019Q32019-2020JanuaryDA05I23887930600   
05-10-20191020192019Q32019-2020JanuaryFI05A1916255276.2   
06-10-20191020192019Q32019-2020January30SYS0410080000   
07-10-20191020192019Q32019-2020January30SYS041002450000   
08-10-20191020192019Q32019-2020January30INT041008840000   
09-10-20191020192019Q32019-2020January30INT04100320000   
10-10-20191020192019Q32019-2020JanuaryEG02I274334696530.55   

please check the uploaded sample data and suggest.

Message 6 of 7
1,433 Views
0
V-lianl-msft
Community Support
Community Support
In response to Anonymous

‎02-13-2022 11:50 PM

Hi @Anonymous ,

 

What is the formula of 50 percentage measure ?

 

 

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

Message 7 of 7
1,389 Views
0
Anonymous
Not applicable

‎02-08-2022 01:36 AM

@amitchandak 

 

Hi,

I didn't got the exact values for the below dax

count = Countx(filter(values(Sales[PARTNERCODE]), [50 percentage] >50.0),[PARTNERCODE])
 
I need count from percentage measure values Greater than 50.00 percentage
Message 4 of 7
1,450 Views
0
Anonymous
Not applicable

‎02-07-2022 12:59 AM

Hi,

I didn't got the exact values for the below dax

count = Countx(filter(values(Sales[PARTNERCODE]), [50 percentage] >50.0),[PARTNERCODE])
 
I need count from percentage measure values Greater than 50.00 percentage.
 
Message 3 of 7
1,476 Views
0
amitchandak
Super User
Super User

‎02-06-2022 11:47 PM

@Anonymous , Try a measure like

 


Assuming percentage is a measure
Countx(filter(values(Table[Part number]), [percentage] >.5),[Partnumber])

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube
Message 2 of 7
1,512 Views
0

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.

February Power BI Update Carousel

Power BI Monthly Update - February 2026

Check out the February 2026 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

View All