Forum Discussion
pezakas
Helper I
Helper IShowing data while dataset is filtered
Hello community, This is my dataset. The user always picks a date from a single selection slicer, that is using the "Dataflow_Date". I would like to create a measure so that when user sel...
NaveenGandhi
Memorable Member
Memorable Memberpezakas
It would not turn up blank if you select January, ALL(effort) here is used to basically neglect the project filter context, Since each year ID is different.
I would suggest to remove the all(effort), Check the output, Then again remove project ID from the table to see whats happening.
Note: Allexcept would be better suited to understand this.
ALLEXCEPT(Effort,Effort[Dataflow_Date])
Let me know if this helps.
Did I answer your question? Mark my post as a solution! Appreciate your Kudos !!
pezakasHelper I
Helper IHm i see. Although, Project_ID has nothing to do with the year. It's the ID of the project, maybe i shouldn't mention it as a column in table at all. I will try what you suggested and share feedback again soon.