Need help Dax

[Anonymous]

Hi Team,

Could you please suggest how to solve below scenario in power bi desktop

[Tahreem24 · Accepted solution]

@Anonymous ,

Try below DAX:

Column = CALCULATE(MAX(Table[PID]),ALLEXCEPT(Table,Table[DCS_Name]))

Also See the below screen shot for the answers:

[Anonymous]

Thanks it works perfectly

[Tahreem24]

@Anonymous  That's awesome.

I would really appreciate your KUDOS/THUMBS UP for support.

[amitchandak]

@Anonymous , you can use the count of column or countrows. You have a slicer that can filter the data. as long as it from the same table and related table no action required

You can have the filter in measure

like

Count = calculate(countrows(Table))

Above will respond to the slicer

Cancer Count  =calculate(countrows(Table), table[disease] = "Cancer")