Forum Discussion
Sumif function only value restriction
Hi Everyone, I have been struggling an issue for hours about dax sumif function. Having I rigid searched I have found CALCULATE(SUM(table)FILTER(table,column)] replies. But these functions does n...
Anonymous
Create the following measure:
Filtered Values = SUMX(VALUES(Sheet1[DistName]),CALCULATE(SUM(Sheet1[Scenario])))
Scenario is the new column which is created before
Can you please help me about this issue ?
Thanks in advance
Anonymous
Although it is a bit difficult to understand the logic, can you try something like the following.
Create a new column:
New_Column = IF([brüt satış] > 200, [brüt satış], 0)
Then on the measure called Scenario:
Scenario = SUM([New_Column])
Dear themistoklis,
Thanks for your reply. But it did not work. I have tried to use calculate(table,filter(column>200)) formula for sumif logic but it did not work too.
Anonymous
Can you show on excel how you want the formula to work?
Input and Output data