Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Creating a dynamic table

Hi everyone, is it possible to create a dynamic table that returns the unique values from a column based on selected slicer. I want to sprint a report to shows daily task count in a a sprint. the num...
Need Help
  • V-lianl-msft's avatar
    V-lianl-msft
    5 years ago

    Hi Anonymous ,

     

    Create a measure like this and apply it to visual level filter.

    Measure = SWITCH(TRUE(),
MAX('Table'[Sprint])="Sprint 10"&&MAX('Table'[Sprint Day])<=3,1,
MAX('Table'[Sprint])="Sprint 11"&&MAX('Table'[Sprint Day])<=2,1,0)

     

    Best Regards,
    Liang
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

amitchandak's avatar
amitchandak
Super User
5 years ago

Anonymous , I dynamic table can not be created using slicer.

 

You can have a dynamic table inside a measure if needed

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    How do I achieve that