Forum Discussion

Wilsonr's avatar
Wilsonr
Helper I
8 years ago

SELECTCOLUMNS - Issue when Using a Measure

I am using SELECTCOLUMNS create a new table called "My_Table" from an existing table called "Dedicated_Measures". I want to recover the "Week", "Product" and "Value" columns for a given week, i.e. 20...
Need Help
v-jiascu-msft's avatar
v-jiascu-msft
Microsoft Employee
8 years ago

Hi Ron,

 

Try to remove "ALL" of "Value 2018W34", which remove the context of Week. 

Value 2018W34 =
    CALCULATE(
        SUM(Dedicated_Measures[Value]),
        FILTER(ALL(Dedicated_Measures[Week]),Dedicated_Measures[Week] = "2018W34")
    )

Best Regards,

Dale

Wilsonr's avatar
Wilsonr
Helper I
8 years ago

Dale,

 

Thanks. I went even further and removed all of the data in table Dedicated_Measures except for the desired Week and Product via the MySQL query which generates this table. So the source table now looks like this:

 

while the SELECTCOLUMNS produces this:

 

How can this be possible?

 

Ron