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.

PaulDBrown's avatar
PaulDBrown
Icon for Community Champion rankCommunity Champion
5 years ago

Anonymous 

Create slicer using the table[Sprint] field (or create a dimension/lookup table with unique table[sprint] vales and join via a relationship to your fact table via the common field) and a table as you have shown. When you select a value(s) in the slicer, the table will be filtered accordingly. 

V-lianl-msft's avatar
V-lianl-msft
Icon for Community Support rankCommunity Support
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.