CALCULATE with filter measure by condition

[Anonymous]

Hi guys!

What is the correct way to do what I'm attempting?

I have 2 measures of SUMS (Soma de Estoque and Soma de Uso).

I want to bring only the values from Soma de Estoque, where the Soma de Uso are below 500.

Thanks in advance!

[Anonymous]

You also can use "visual filter" with "Soma de Uso" below 500.

[PGAndrade]

Hello @Anonymous sup?
In this case the "Soma de Uso" realy need to be a measure? If it could be a  calculated column then you can use it as a Filter like in the folowing expression:
CALCULATE([Soma de Estoque]; TableName[Soma de Uso] > 500)

If they must be measures a straighfoward solution is the following:
Low Usage = IF([Soma de Uso] < 500; [Soma de Estoque]; BLANK())

[Anonymous]

@PGAndradehi!

I ended up doing it like that: Low Usage = IF([Soma de Uso] < 500; [Soma de Estoque]; BLANK())

But that affected my performance for a lot of data.

[PGAndrade]

Let me see @Anonymous,
Have you tried the @Greg_Deckler solution? Maybe that one has a better performance, if you had some issues understanding the expression I could explain it to you.

[Greg_Deckler · Accepted solution]

Probably something along the lines of:

Measure =
VAR __table = SUMMARIZE('Table',[PN],[Vendor],"__SomadeEstoque",[Soma de Estoque],"__SomadeUso",[Soma de Uso])
RETURN
SUMX(FILTER(__table,[__SomadeUso]< 500),[__SomadeEstoque])

[Anonymous]

Did you create a new table with the SUMMARIZE and then created a measure with RETURN?

[Greg_Deckler]

So yes and no, it creates a table in memory as a variable, not in the data model.