Forum Discussion

pezakas's avatar
pezakas
Icon for Helper I rankHelper I
3 years ago

Showing 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...
Need Help
Tips and Tricks
pezakas's avatar
pezakas
Icon for Helper I rankHelper I
3 years ago

Does this work if you select the January from date slicer? Or it returns blank()?
When you set ALL(Effort) it means you clear the whole table from filters , right? 

NaveenGandhi's avatar
NaveenGandhi
Icon for Memorable Member rankMemorable Member
3 years ago

pezakas 

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 !!


 

  • pezakas's avatar
    pezakas
    Icon for Helper I rankHelper I
    3 years ago

    Hm 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.