Count rows on selected months

Hi,

Since i have not understood the logic of the Yes/No, i have not been able to generate that column.  You may download my PBI file from here.

Hope this helps.

Hi TrulsB,

You could refer to Ashish_Mathur 's file, if you want to get total in column and row, you could turn subtotal button like below

If you want to get start date- stop date in last column, you could try to use below measure to replace measure in above file

Measure =
IF (
    HASONEVALUE ( 'Attribute order'[Attribute] ),
    DISTINCTCOUNT ( Data[Projectname] ) + 0,
    CALCULATE (
        DISTINCTCOUNT ( Data[Projectname] ),
        FILTER ( 'Attribute order', 'Attribute order'[Attribute] = "Start date" )
    )
        - CALCULATE (
            DISTINCTCOUNT ( Data[Projectname] ),
            FILTER ( 'Attribute order', 'Attribute order'[Attribute] = "Stop date" )
        ) + 0
)

Best Regards,
Zoe Zhi

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