Forum Discussion

Wilsonr's avatar
Wilsonr
Icon for Helper I rankHelper 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
Icon for Microsoft Employee rankMicrosoft 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
    Icon for Helper I rankHelper 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

  • Wilsonr's avatar
    Wilsonr
    Icon for Helper I rankHelper I
    8 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
      Icon for Helper I rankHelper I
      8 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
        Icon for Microsoft Employee rankMicrosoft Employee
        8 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