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.

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Below is a sample data.

 

I want to the table to show Days: 1,2,3 when I select Sprint 10 and just 1,2 when I select Sprint 11

 

Sprint DaySprintTasksAssignedHours
1Sprint 10Task 1User A2
1Sprint 10Task 2User A1
2Sprint 10Task 1User B2
3Sprint 10Task 3User C1
1Sprint 11Task 1User C2
2Sprint 11Task 5User A1
PaulDBrown's avatar
PaulDBrown
Community 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
    Community 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.