Forum Discussion
NoIdea
3 years agoRegular Visitor
Basic CALCULATE question OR a strange phenomenon
Hello, I have a question regarding the following simple Measure that does not give the result that I would expect. I would like to know if it is my lack of PBID / DAX understanding (I am new to i...
- 3 years ago
Have a look at this
https://www.sqlbi.com/articles/side-effects-in-dax-of-the-sort-by-column-setting/
HotChilli
Community Champion
3 years agoCan you link the pbix please and I'll have a look?
- NoIdea3 years agoRegular Visitor
I couldn't figure out how to attach a pbix file, so here is the basic info:
Model:
Measures:
SumValue = SUM( Results[Value] ) SumValue Start = CALCULATE( SUM( Results[Value] ), TimePoint[TimePoint_Mo] = "Start" ) SumValue Start FILTER = CALCULATE( SUM( Results[Value] ), FILTER( TimePoint, TimePoint[TimePoint_Mo] = "Start" ) ) SumValue Start FILTER wALL = CALCULATE( SUM( Results[Value] ), FILTER( ALL( TimePoint[TimePoint_Mo] ), TimePoint[TimePoint_Mo] = "Start" ) )Visuals
Meanwhile, my first question is, what should be the result of following measure using a matrix-visual?
SumValue Start = CALCULATE( SUM( Results[Value] ), TimePoint[TimePoint_Mo] = "Start" )What data should be displayed?