DAX Expression to Generate Table Seen in Show Data of a Column Chart

[antel1]

Hi,
I have a basic column chart that displays the value of a measure (that calculates the average time of a process) split into categories (the different processes).

There is an option in Power BI that allows you to show the data that the table is displaying.

Is there is a way to generate this table through a dax expression? I've tried using the following summarize command

SUMMARIZE(OPOrder, OPOrder[OPName], "AvgOp", [AvgOpFiltered])

However the numbers generated are incorrect.



I need to generate this table as a step in a further calculation. What am I doing wrong in my expression? Or is there an alternative expression I have yet to discover?

Thanks

[antel1]

Find out half of my issue however I still have a problem.

The measure [AvgOpFiltered] is based on the value of a 'What If' parameter. In my calculation, it assumes this parameter is equal to the default 0. How can I make the table update based on the what if parameter?

[Zubair_Muhammad · Accepted solution]

Hi @antel1

Calculated tables are similar to calculated columns. They are based on underlying source data and are re computed only when the data is refreshed. So they wont respond to WHAT if parameteres.

As an alternative,  you can drag the OPName field and this MEASURE to a Table Visual