Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Keep filtered value in new table

Hi all,   I am trying to create a table similar to the line graph's as below:     However this line graph is filtered by a slicer and depending on the filter applied, the estimated kWh wou...
DAX
Filtering
tables
  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Thanks Greg. I will try again, and have attached the pbix file for context  :

     

    1. I have metered data for a few different sites (identified by MeterSerialNumber1)

     

    2. I plot them as a line chart to get :

    Note that I have filters on the MeterSerialNumber1

     

    3. For the line chart, if I click "Show as a table", the table shown as below:

     Which is a sum of kWh for all the filtered MeterSerialNumber1 grouped by the Date.

     

    My problem is:
    I want to create a NEW table as pointed by the blue arrow above. But keeping in mind that it varies with different combination of MeterSerialNumber1 selected. i.e. kWh column for 1/1/2019 12:30:00 a.m. will differ with different combination based on filter on slicer. 

     

    The next step for me is so that I can add another column of values (in this case, will be estimated kWh), then I can do a "calculated" New Column (actual + estimated). 

     

    Thanks.

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Hi there

      I am experiencing a similiar issue. I have tried using SUMMARIZECOLUMNS(Table['Date'],AnotherTableThatHasDataLinkandSlicersApplied,'kWh',SUM(Table['kWh']) and SUMMARIZECOLUMNS(Table['Date'],'kWh',SUM(Table['kWh']). Are these even the right functions?

      I, like you, just want to make a table that is has same results as what is showing when select 'Show Data' on graph

       

      Any help would be greatly apprecaited, this is driving me nuts!