How to dynamically refresh a DAX table created by measure

[yishenhui]

Hi,

I created a mesure and a DAX table to count them by the range. The result as screenshot 1. The counting is good. Then I adjust the parameter (at left up area). The measure of totalscore and scorerange calculated fine. But the counting table doesn't refresh accordingly. How can I get the table refresh dynamically? 

The DAX of the counting table is 

ScoreCountTable = filter( ADDCOLUMNS ( CROSSJOIN ( VALUES ( DataQuery[analystname] ),values(dataquery[logdate]), VALUES ( Marks[Mark] ) ), "ScoreRange", [ScoreRange], "mark-score",[Mark]-[ScoreRange],"Analystnamelogdate",[analystname] & format([LogDate],"M/D/YYYY") ),[Mark]-[ScoreRange] =0)

The DAX of table Marks is

Marks = SELECTCOLUMNS ( GENERATESERIES ( 0, 100,1 ), "Mark", [Value] )

The DAX of the measure ScoreRange is 

ScoreRange = floor([TotalScore],5)

The DAX of measureScoreCount is

ScoreCount = COUNTROWS ( 'ScoreCountTable')

The table visual just use the counting table column Scorerange and measure scorecount.

[Anonymous]

HI @yishenhui,

AFAIK, current power bi does not support create dynamic calculated column/table based on filters. They worked on the different data levels, and you can't use child level to affect their partner level.

Notice: the data level of power bi(from parent to child level)

Database(external) -> query table(query, custom function, query parameters) -> data model table(table, calculate column/table) -> data view with virtual tables(measure, visual, filter, slicer)

Regards,

Xiaoxin Sheng