Home Forums Data Warehousing PowerPivot create summaries in DAX in Excel/PowerBI (not Analysis Services) RE: create summaries in DAX in Excel/PowerBI (not Analysis Services)

  • April 20, 2016 at 12:10 am

    #1873228

    I'm just slow...

    This worked:

    HighestGrades = SUMMARIZE('Toxicity'

    ,Toxicity[Protocol]

    ,Toxicity[PatientKey]

    ,Toxicity[Symptom]

    ,"Worst Grade",MAX(Toxicity[Grade]))

    Then I based my reporting on that.