Forum Discussion
How to hide lines in pivot table, that have no value in a certain sum-value-column?
Hello everyone, I hope someone is willing to help me with my Pivot Challenge. The actual question is below. I use a Pivot Table on the following datamodel: In my Pivot Table I see the ...
In any case it's better to use explicit measures instead of implicit ones. Thus for Spent it could be
Time Spent:=SUM( Billings_Table[SPENT] )To calculate Estimate from many to one relationship, we may use virtual relationship in measure
Time Estimate :=
CALCULATE (
SUM ( Tasks_Table[ESTIMATE] ),
TREATAS ( VALUES ( Billings_Table[TASK_ID] ), Tasks_Table[TASK_ID] )
)
or existing physical one with crossfilter
Estimated Time :=
CALCULATE (
SUM ( Tasks_Table[ESTIMATE] ),
CROSSFILTER ( Billings_Table[TASK_ID], Tasks_Table[TASK_ID], BOTH )
)
Both work, please check in attached file.
SergeiBaklanThank you for pointing me in the right direction and providing a solution. It obviously does what I want. Now I have to read up on TREATAS and CROSSFILTER.