Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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() )
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
97 | |
77 | |
63 | |
55 |
User | Count |
---|---|
143 | |
109 | |
89 | |
84 | |
66 |