Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
yishenhui
Helper II
Helper II

How to dynamically refresh a DAX table created by measure

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.

 

image.pngimage.png

1 REPLY 1
Anonymous
Not applicable

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

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.