Forum Discussion

Arnoux's avatar
Arnoux
Frequent Visitor
7 years ago
Solved

Filter dataset before applying summarize (create new table ) statement

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...
Show and Tell
  • v-yuta-msft's avatar
    v-yuta-msft
    7 years ago

    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.

v-yuta-msft's avatar
v-yuta-msft
Icon for Community Support rankCommunity Support
7 years ago

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.