Filter dataset before applying summarize (create new table ) statement

[Arnoux]

I have a data model in PowerBI which consists of a Fact Table and a dimesnion

For simplicity sake ill call it Fact and Dimension.

Fact:

FactID	DimesnionID	Value	DateTime
1	1	0	1/1/2019 08:01
2	1	1	2/1/2019 08:02
3	2	1	3/1/2019 08:03
4	1	1	4/1/2019 08:15
5	3	1	5/1/2019 08:30
6	3	0	6/1/2019 08:45
7	3	1	7/1/2019 08:00

Dimesnion

DimensionID	Name
1	A
2	B
3	C
4	D
5	E
6	F
7	G

The relationship between these 2 tables are dimesnionid on dimensionid

Now I need to create a Summarize statement like the following:

Table =
SUMMARIZE (
    'Fact',

    'Dimension'[Name],
    "Value",SUM('Fact'[Value])

)

Now this seems to work as a once off.

But now when i filter the date on the front end in a filter. The values of the calculated table does not adjust according to the filter.

So ideally I would like a solution where the summarize statement is based on the filtered set of data on the fact and not the full dataset.

So When i filter the datetime on the report. The table must recalculate based on a new subset of Fact Records.

Im stuck.

Please help.

Arnoux

[v-yuta-msft · Accepted solution]

@Arnoux ,

Power bi doesn't support dynamic calculate column/table so I'm afraid this can't be achieved. Filters/Slicer charts are in view level while the summarized table is in model level, in power bi, view level can't filter data in model level.

Community Support Team _ Jimmy Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.