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!