Forum Discussion

jbarta's avatar
jbarta
Advocate II
8 years ago
Solved

DAX Help!

I am new to Power BI and the DAX language. I have been working with SQL server and T-SQL for almost 10 years now and my skills in DAX are not at the same level as T-SQL. I have been asked to create a...
Need Help
  • Drors's avatar
    Drors
    8 years ago

    Hi,

    You can do it with a summerized table

    create new dax table :

    SummerizedTable = SUMMARIZE(Table1,Table1[PatientProfileId],"Counter",COUNTROWS(Table1))

     

    after that you have to make a relationship between the summerizedtable and your original table.

    Then you just need to create new chart put the "counter" column in the x axis and in the value put the patienID and change it to count (if you take the column from the original table make it count distinct).

     

    after you can add any filter you want.

     

Drors's avatar
Drors
Resolver III
8 years ago

Hi,

You can do it with a summerized table

create new dax table :

SummerizedTable = SUMMARIZE(Table1,Table1[PatientProfileId],"Counter",COUNTROWS(Table1))

 

after that you have to make a relationship between the summerizedtable and your original table.

Then you just need to create new chart put the "counter" column in the x axis and in the value put the patienID and change it to count (if you take the column from the original table make it count distinct).

 

after you can add any filter you want.

 

jbarta's avatar
jbarta
Advocate II
8 years ago

I think this will work. Thanks for responding!