Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
samcaicn
Frequent Visitor

Percentage of total

Hello

in a column:

 

I would like to calculate bigger than 1.9 values rows as a percentage of total rows.

 

What is the measure I have to apply?

2 ACCEPTED SOLUTIONS

Can you please provide some sample data


To learn more about DAX visit : aka.ms/practicalDAX

Proud to be a Datanaut!

View solution in original post

Hi @samcaicn

 

New Measure = 
	DIVIDE(
		CALCULATE(
			COUNTROWS('OUT_ACTIVE'),
			'OUT_ACTIVE'[ACTIVE]>1.9
			)
			, 
			CALCULATE(COUNTROWS('OUT_ACTIVE')
			)
		)

To learn more about DAX visit : aka.ms/practicalDAX

Proud to be a Datanaut!

View solution in original post

8 REPLIES 8
samcaicn
Frequent Visitor

i try:

 

DIVIDE(COUNTROWS(OUT_ACTIVE[ACTIVE],OUT_ACTIVE[度量值]>1),ALL(OUT_ACTIVE[ACTIVE]))

 

 

doesnot work!

 

 

 

 

creat new colum= (FILTER(OUT_ACTIVE[ACTIVE]),VALUES(OUT_ACTIVE[ACTIVE])>1.9)

 

also doesnot work!

Have you tried creating it as a Measure?


To learn more about DAX visit : aka.ms/practicalDAX

Proud to be a Datanaut!

Thanks for ur reply so much,

 

may u give out the writting?

 

Thanks

Can you please provide some sample data


To learn more about DAX visit : aka.ms/practicalDAX

Proud to be a Datanaut!

ACTIVE

1.986356146
1.808821736
1.808821736
1.808821736
1.810247903
1.808821736
1.808821736
1.808821736
0
1.930190799
1.808821736
1.810247903
1.810247903
 
1.871044056
1.808821736
1.844600473
1.810247903
1.808821736
0
1.808821736
1.812897039
1.847597763
1.808821736
0
1.808821736
1.808821736
 

 

i tried creat measure,but COUNTX can't use with >1.9

 

so,ps help

Hi @samcaicn

 

New Measure = 
	DIVIDE(
		CALCULATE(
			COUNTROWS('OUT_ACTIVE'),
			'OUT_ACTIVE'[ACTIVE]>1.9
			)
			, 
			CALCULATE(COUNTROWS('OUT_ACTIVE')
			)
		)

To learn more about DAX visit : aka.ms/practicalDAX

Proud to be a Datanaut!

Thanks so much  big boss!

 

may u give out another way by creating column like this: FILTER('OUT_ACTIVE'[ACTIVE]>1.9,OUT_ACTIVE[ACTIVE]) ?

 

so i can draw it out with a circle map.

If you'd like the data to be in a new column you could always try

 

New Column = IF(
            ---- CONDITION ----
            'OUT_ACTIVE'[ACTIVE] > 1.9,
            ---- THEN ----
            'OUT_ACTIVE'[ACTIVE],
            ---- ELSE ----
            BLANK()
            )

To learn more about DAX visit : aka.ms/practicalDAX

Proud to be a Datanaut!

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.