Forum Discussion
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 the normal visual filters of Power Bi.
Maybe i can create two other calculated measures called >1 and <1, but i can't find the formula.
Can you help me?
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
4 Replies
- themistoklis
Community Champion
You can use Filter_Type = Advanced Filtering and not Basic Filtering from Filter Pane.
This way you can advantage of the AND or OR statements
- amitchandak
Super User
Botturovic , You can put a viusal level filter to filter measure values
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
