Get column values from table

I'm not sure quite the desired output, but it looks like you're trying to say:

Sum Sales[Value]

Where month is the current row month

and Flag1 = "No"

and the current store, month, area and item has to exist in the table with Flag2 = 1 ?

If so, I rewrote a little to optimize:

=
VAR _month = Sales[Month]
VAR _area = Sales[Area]
VAR _item = Sales[Item]
VAR _store = Sales[Store]
RETURN
    CALCULATE (
        SUM ( Sales[Value] ),
        FILTER (
            Sales,
            Sales[Month] = _Month
                && [Flag1] = "No"
                && Sales[Store]
                    IN CALCULATETABLE (
                        VALUES ( Sales[Store] ),
                        Sales[Month] = _month,
                        Sales[Area] = _area,
                        Sales[Item] = _item,
                        Sales[Flag2] = 1
                    )
        )
    )

Right now, it sums the store only if that record has any value where store, month, area  exists in the table with Flag2 = 1.

If you actually wanted:

Sum Sales[Value]

Where month is the current row month

and Flag1 = "No"

and the current row store,

and the current row month,

and the current row area

and Flag2 = 1 

then:

	
=
VAR _month = Sales[Month]
VAR _area = Sales[Area]
VAR _item = Sales[Item]
VAR _store = Sales[Store]
RETURN
    CALCULATE (
        SUM ( Sales[Value] )
			,Sales[Month] = _Month
            ,[Flag1] = "No"
			
		,FILTER (
            Sales
				Sales[Store] =_store,
                Sales[Month] = _month,
                Sales[Area] = _area,
                Sales[Item] = _item,
                Sales[Flag2] = 1
                    )
        )

Love hearing about Power BI tips, jobs and news?
I love to share about these - connect with me!

Stay up to date on  
Read my blogs on  

Remember to spread knowledge in the community when you can!