Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Administrator
4 years ago

Dynamically update values from a table created with DAX

Hello, good afternoon

I have to create the following funnel chart.

Yeztrom_0-1644364076928.png

Of which the values it shows corresponds only to measures, for this it is necessary to create a table with dax where the measures are grouped.

Yeztrom_2-1644364972335.png

Showing in the graph the fields Type and Quantity.

Yeztrom_3-1644365047471.png

In this way the graph shows the values that I want correctly but the problem I have is that in the pages of the report you have date segmenters and you want the value of the measures to correspond to the selected period but I do not get the table updated according to the selected period, it shows the measures calculated based on the totality of the data which is correct if the entire period is selected of which you have data but not when a specific period is filtered.

I hope you can help me with this problem.

Best regards.

2 Replies

  • Syndicate_Admin's avatar
    Syndicate_Admin
    Administrator
    2 years ago

    Sorry for the inconvenience, you found a way to solve it??? I have a similar situation where I create a table with DAX and I would expect that a date segmentation can dynamically change a report