CHALLENGE: Help with filters. Sum values from fact table in dimension table and apply filters. (Diagram included).

[zapppsr]

Hi guys. I have a, in my knowledge, complex case to solve.

I need to summarize values in a table, because I need the values grouped to create a relationship with another table. I can't do it with a measure, as far as I know.
I'm explaining this because without my goal, my request can be misunderstood.

Here is what I need:

• I need to apply filters in a Power Bi page and those filters be acknowledge by the dAccount table.

Probably the solution lies in adding some filters in the value expression.
Obs.: In my real model, I have a Calendar Table and I will adapt the solution using it.

 

[zapppsr]

Hi Andrey. Thanks again for putting so much effort and helping me. That last one solution os very nice, dynamic and all.
I just didn't understand the values for filters, both_filter, none_filter owner_filter and so on... Did you put them there manually, on the source table?

I have been searching the Power Bi community forum and I think they are close to implement a solution for this in a near future release.
There is also a import KPI from Power Pivot feature that is in preview.

I think I better wait for something on the tool itself.

Thanks again for helping me.