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
Anonymous
Please see atatched workspace
Create a new column and then add it to the table.
Scenario = IF(Sheet1[Sales]>200, Sheet1[Sales],0)
Dear themistoklis ,
Thanks for huge help. It works but another issue has been occured which is wrong total. nonfiltered sum(brüt satış) and filtered sum(scenario) is same but filtered some (>200 ) should have been lower than unfiltered ones. You can see the picture below. Can you fix this ?
Anonymous
Create the following measure:
Filtered Values = SUMX(VALUES(Sheet1[DistName]),CALCULATE(SUM(Sheet1[Scenario])))
Scenario is the new column which is created before
Dear themistoklis,
You are man of the day. Huge thanks for your efforts to understand my issue and collaboration.