Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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!
Solved! Go to 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])
You also can use "visual filter" with "Soma de Uso" below 500.
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())
@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.
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.
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])
Did you create a new table with the SUMMARIZE and then created a measure with RETURN?
So yes and no, it creates a table in memory as a variable, not in the data model.