Display rows according to a value in a column

[alportela]

Hello guys,
I am very new to power bi. I might be struggling in some of the concepts of the system, but I can't figure it out.

I have 03 columns and 01 measure. The measure is basically the sumx of the columns 02 and 03.
How can I display in the table view all the records (rows) that are above certain value in the measure row. Let's say, show all records that are above the value of 10.000. The number is from the sumx and not from the number of rows.

Any ideias?

[ValtteriN · Accepted solution]

Hi,

You can create filter measure and use this in your visual to display these rows. 

Example:

Data:

DAX:

SUMX10k = SUMX('Over 10k','Over 10k'[Column1]+'Over 10k'[Column2])

Filter measure 10k = IF([SUMX10k]>10000,1,0)

End result (note the filter. You don't need to place the filter measure in the table it is there as an example):

I hope this post helps to solve your issue and if it does consider accepting it as a solution and giving the post a thumbs up!