DAX - countrows for a visual with filter on a measure

[057Sophie]

Hello all

I am struggling with some tiny issue I guess.

I have a visual wich is filtered on a measure, the measure is updated/calculated according to what "project" is selected (above right corner)

There I was able to get all the lines related to this project and the first measure works fine, and displays ALL lines related to the item ID from the source table with:

Calculate(COUNT('MBOM Extract Code Matrix'[BOM Line]),ALLEXCEPT('MBOM Extract Code Matrix','MBOM Extract Code Matrix'[Item ID]))

Now my struggle is to display the same kind of measure but showing the number of bomlines for eache item id once I have selected the project and where specific line = Yes (column Nb lines for project)

For example I would like to see as result 4 for EI-0000019096 and 2 for SI-0000000329,

My goal is to have a check/test lie: if nb selected bomlines fro project = nb of lines in MBOM then TRUE else False or something like this.

But I was trying to decompose this measure in several steps first.

Thank you

[057Sophie · Accepted solution]

I finally mastered it with: 

Nb lines for the project =
CALCULATE(COUNTROWS('MBOM Extract Code Matrix'),

FILTER(ALLSELECTED('MBOM Extract Code Matrix'),'MBOM Extract Code Matrix'[Item ID]=SELECTEDVALUE('MBOM Extract Code Matrix'[Item ID])))