Forum Discussion

ghouse_peer's avatar
ghouse_peer
Icon for Post Patron rankPost Patron
3 years ago

Dax to get Backlog count

Hi team,    I have a requirement to show the backlog count in Line y axis in Line and clustered column chart.   My data is in excel file Type Month Status Counts PBI 1/1/2022 Open 12...
Need Help
Show and Tell
v-xiaotang's avatar
v-xiaotang
Icon for Community Support rankCommunity Support
3 years ago

Hi ghouse_peer 

Thanks for reaching out to us.

you can try this measure

Measure = SUMX(FILTER(ALL('Table'),YEAR('Table'[Month])=YEAR(MIN('Table'[Month])) && MONTH('Table'[Month])= MONTH(MIN('Table'[Month])) && 'Table'[Status]="Backlog"),[Counts])

it calculates the total of Backlog in each month.

 

 

 

Best Regards,

Community Support Team _Tang

If this post helps, please consider Accept it as the solution to help the other members find it more quickly

ghouse_peer's avatar
ghouse_peer
Icon for Post Patron rankPost Patron
3 years ago

Hi v-xiaotang thanks for the help,

 

i tried this measure but getting error at 

'Table'[Status]= "Backlog"),[Counts]), error: Cannot find name "Backlog", but in my data it is same as i mentioned. Kindly help