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.

     

v-xjiin-msft's avatar
v-xjiin-msft
Solution Sage
8 years ago

Hi jbarta,

 

=> I need to know how many patients in a giving time period had 1 appointment, how many had 2 appointments, etc.

 

I still not quite understand about the logic of your requirement. How to get these 1 appointment or 2 appointments, etc? 

 

Since you have already shared us some sample data. What's your expected result based on this sample data? With expected result, it'll lead us the right direction.

 

Thanks,
Xi Jin.

jbarta's avatar
jbarta
Advocate II
8 years ago

Thanks for responding! I did receive another post that pointed me in the right direction.