Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Need help Dax

Hi Team,

 

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

Need Help
  • Tahreem24's avatar
    Tahreem24
    6 years ago

    Anonymous ,

    Try below DAX:

    Column = CALCULATE(MAX(Table[PID]),ALLEXCEPT(Table,Table[DCS_Name]))
    Also See the below screen shot for the answers:
     
     

4 Replies

  • Tahreem24's avatar
    Tahreem24
    Super User
    6 years ago

    Anonymous ,

    Try below DAX:

    Column = CALCULATE(MAX(Table[PID]),ALLEXCEPT(Table,Table[DCS_Name]))
    Also See the below screen shot for the answers:
     
     
    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Thanks it works perfectly

      • Tahreem24's avatar
        Tahreem24
        Super User
        6 years ago

        Anonymous  That's awesome.

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

         

         

  • amitchandak's avatar
    amitchandak
    Super User
    6 years ago

    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")