Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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?
Solved! Go to Solution.
Can you please provide some sample data
Hi @samcaicn
New Measure = DIVIDE( CALCULATE( COUNTROWS('OUT_ACTIVE'), 'OUT_ACTIVE'[ACTIVE]>1.9 ) , CALCULATE(COUNTROWS('OUT_ACTIVE') ) )
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?
Thanks for ur reply so much,
may u give out the writting?
Thanks
Can you please provide some sample data
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') ) )
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() )
User | Count |
---|---|
139 | |
113 | |
103 | |
77 | |
63 |
User | Count |
---|---|
135 | |
126 | |
110 | |
70 | |
61 |