Forum Discussion

gvg's avatar
gvg
Post Prodigy
9 years ago
Solved

Using table as filter in power bi

Hi all, I am trying to solve this probably simple problem but came up with strange result. I have a tLevels table with different grouping levels like this:   Lev1     Lev2     ProductID 1        ...
Need Help
zivhimmel's avatar
zivhimmel
Resolver I
9 years ago

If you want to show Amount by Lev1,

the measure will simple be =SUM(Amount).

You don't even have to create a measure for it, just create a visual with tLevels[Lev1] and tSales[Amount]

and make sure the aggregation used for tSales[Amount] is SUM.

 

The problem with the measure you've created is that CALCULATE changes the context filter for the fields you are filtering by

(in this case tLevels[Lev1]). The second argument to CALCULATE is a flter. You just used tLevels[Lev1] as a filter,

which always returns TRUE, therefore all values are the same.

 

I hope that helps.

 

Ziv Himmelfarb

https://www.superfarb.com

 

gvg's avatar
gvg
Post Prodigy
9 years ago

Thanks for the comments. I actually tried to put up a table visual without any measures before posting this question. It returns even more strange result:

 

My table relationship looks like:

 

 

It doesn't help if Cross filter direction is Both or Single.