Filter in a measure

[Botturovic]

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?

[Botturovic]

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-msft · Accepted solution]

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

[amitchandak]

@Botturovic , You can put a viusal level filter to filter measure values

[themistoklis]

@Botturovic 

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