Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Sort by Column function influence measure result

Hi All.

Ok, so this is the strangest one, which I came across so far.

First, let me describe the part, which is understable.

 

I have a simple model, which contains one fact table and one dimension table with Account.

 

Then I've created a measure, which calculates sum of column value for account ZwykleKonto1

 

Measure = CALCULATE(sum(factFact[Value]), dimAccount[Account] = "ZwykleKonto1")
 
When I create a table visual with Account and Measure it looks like below, which is completly reasonable to me (measure filter overwrites context filter).

 

Now let's start with the mistic part. When I sort column Account by column Sorter, Measure starts to reflect 0 for Accounts with different Sorter value then 50 (which is value for ZwykleKonto1). I completly do not understand this behavious. Can I ask for explanation please?

 

 

 

 

Many Thanks, Kamil.

2 Replies