Forum Discussion
Solved
Filter in a measure
Hello everyone, I would need to filter the values of a column to separate the values = or > to 0, and the values < to 0. The values in the column come from a measure, but i can't manage to use t...
Hi Botturovic ,
You can create something like below:
Risultato% >1 = VAR A = SUMMARIZR('Table','Table'[ID],"_Risultato%",[Risultato%Comm]) RETURN COUNTX(A,[_Risultato%]>1)/COUNTROWS(A) Risultato% <1 = VAR A = SUMMARIZR('Table','Table'[ID],"_Risultato%",[Risultato%Comm]) RETURN COUNTX(A,[_Risultato%]<1)/COUNTROWS(A)If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Best Regards,
Dedmon Dai
Thank you for your answers,
But what i need is to find the percentage of data over 0 and under 0,
so i assume i need to create somehow two measures from the original, splitting the original measure in >1 and >1 (0r >0 and >0)
v-deddai1-msftCommunity Support
Hi Botturovic ,
You can create something like below:
Risultato% >1 = VAR A = SUMMARIZR('Table','Table'[ID],"_Risultato%",[Risultato%Comm]) RETURN COUNTX(A,[_Risultato%]>1)/COUNTROWS(A) Risultato% <1 = VAR A = SUMMARIZR('Table','Table'[ID],"_Risultato%",[Risultato%Comm]) RETURN COUNTX(A,[_Risultato%]<1)/COUNTROWS(A)If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Best Regards,
Dedmon Dai