Forum Discussion

Wilsonr's avatar
Wilsonr
Helper I
7 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
7 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
7 years ago

Dale,

 

I made the edit you suggested and it worked. I am using the ALL because I have slicers attached to my Dedicated_Measures in order to select the Week.

 

Also, while SELECTCOLUMNS gives me the undesired result when using the ALL(), replacing it with SUMMARIZE works:


Unfortunately, I don't understand why using ALL is a problem? Can you explain?

 

Thanks in advance,

Ron

  • Wilsonr's avatar
    Wilsonr
    Helper I
    7 years ago

    Dale,

     

    I spoke too soon in my reply below - removing the ALL() makes no difference. So while SELECTCOLUMNS doesn't work, SUMMARIZE works.

     

    I wanted to attach the file, but can't find a way to do so.

    Thanks in advance,

    Ron

    • v-jiascu-msft's avatar
      v-jiascu-msft
      Microsoft Employee
      7 years ago

      Hi Ron,

       

      You can upload the file to the cloud service like OneDrive, GoogleDrive then share the download link here. 

      It seems something wrong with your data structure.

       

      Best Regards,

      Dale