Percentage of total

[samcaicn]

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?

[Phil_Seamark · Accepted solution]

Can you please provide some sample data

[samcaicn]

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!

[Phil_Seamark]

Have you tried creating it as a Measure?

[samcaicn]

Thanks for ur reply so much,

may u give out the writting?

Thanks

[Phil_Seamark · Accepted solution]

Can you please provide some sample data

[samcaicn]

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

[Phil_Seamark · Accepted solution]

Hi @samcaicn

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

[samcaicn]

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.

[Phil_Seamark]

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()
            )