Forum Discussion
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.
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.
- Anonymous4 years ago
After some research I found an article describing this behaviour.
2 Replies
- amitchandakSuper User
Anonymous , Try like
Measure = CALCULATE(sum(factFact[Value]),filter( dimAccount, dimAccount[Account] = "ZwykleKonto1"))
refer
http://dataap.org/blog/2019/04/22/difference-between-calculate-with-and-without-filter-expression/
- AnonymousNot applicable
After some research I found an article describing this behaviour.