Forum Discussion
Helper IVRelative Date Slicer and ALL Function not working
Ive tried that. Something else must be going on.
With the relative slicer and all(dimdate) i get the following which is not what I want.
The table the right is showing the correct total dollars 1.9MM I want it to list all the fee installments that make that up (they go back to 2018)
This sort of works but
1) it does not work with the realive date slicer above2) if I include the date field in the table on the left then the table on the right only shows that one date but I want the table on the right show all dates for the selected project. I want it to ignor the date on the selected project and not propogate it through to the other table.
Super UsermgrayTCB , simply use all or allselected on date tbale
example
NetCurrentFee (all dates) =
var _projFee =
CALCULATE(
[NetFeeCurrent],
all(Rev[DateActOrEst],Rev[TagActOrEst]),
All(dimDate)
)
return
if(HASONEVALUE(Project[ProjectName]),_projFee,BLANK())
or
NetCurrentFee (all dates) =
var _projFee =
CALCULATE(
[NetFeeCurrent],
All(dimDate)
)
return
if(HASONEVALUE(Project[ProjectName]),_projFee,BLANK())
mgrayTCBIve tried that. Something else must be going on.
With the relative slicer and all(dimdate) i get the following which is not what I want.
The table the right is showing the correct total dollars 1.9MM I want it to list all the fee installments that make that up (they go back to 2018)
This sort of works but
1) it does not work with the realive date slicer above2) if I include the date field in the table on the left then the table on the right only shows that one date but I want the table on the right show all dates for the selected project. I want it to ignor the date on the selected project and not propogate it through to the other table.