Forum Discussion

santhidhanuskod's avatar
santhidhanuskod
Regular Visitor
2 years ago

TopN records within custom table

Hi,   I have created 2 custom tables from the main table using DAX  query. Active milestones = FILTER('Live Query', ('Live Query'[workflow_stage_name] IN {"In Progress","In Progress - Green","In ...
Need Help
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
2 years ago

santhidhanuskod , You should create a measure

//change to include the filter from first column

 

M1  = countrows( FILTER('Live Query', AND(
'Live Query'[workflow_stage_name] = "Completed",
'Live Query'[planned_due_date].[Date] >= TODAY() - 14))   )

 

Then have top N Measure

calculate([M1] ,TOPN(3,allselected('Active milestones'[planned_due_date]),[M1]), values('Active milestones'[planned_due_date]))

 

choose the correct columns as needed

 

Learn Power BI: Dynamic TOPN using TOPN/Window and Numeric parameter: https://youtu.be/vm2mdEioQPQ