Forum Discussion

rigosakh's avatar
rigosakh
Frequent Visitor
8 years ago

Hi Avi, 

 

Thank you for the fast reply and an informative video. I can imagine your confusion :) The reason why I'm doing this unusual thing is because I'm terrible at DAX and struggle to create complicated DAX formulae. I'm migrating from doing analysis in Excel and some calculations that relied on extensive use of pivot tables are hard for me to translate into Power BI format. The second (simplified) table was used as a pivot table in excel. I got rid of referencing the query to create a secondary table and  now use SUMMARIZECOLUMNS instead. However, the problem remains the same - the filter doesn't control a table created by SUMMARIZECOLUMNS

 

Please see the snapshot of original data below ("site" ranges between  ~1-1000, time between 8am-6pm):

 

 

Then using SUMMARIZECOLUMNS I create a new table to count how many times in total each product was registered per day

 

Then I need to calculate how many 1 values in "frequency" there are, 2 , 3 etc . Then it is also used for another calculation. I'm relatively new to DAX and can't get my head around how to use SUMMARIZECOLUMNS in a measure without creating a new table. 

  • v-yulgu-msft's avatar
    v-yulgu-msft
    Microsoft Employee
    8 years ago

    Hi rigosakh,

     

    You have resolved the original problem via the suggestion in above link you provided, right? If so, would you please accept your sharing solution so that others having similar concern can find the answer more easily?

     

    Regards,

    Yuliana Gu

    • rigosakh's avatar
      rigosakh
      Frequent Visitor
      8 years ago

      Hi v-yulgu-msft ,

       

      Yes, I've solved the original problem and marked the post with a link as accepted solution. However, this solution caused another issue and I'm not sure whether I should create another topic with a new question or continue posting here ?