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?
NoIdea
3 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?