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.

     

jbarta's avatar
jbarta
Advocate II
8 years ago

I appreciate you mocking that up and taking the time to respond. I do know enough Dax and about Power BI Desktop to create those things. The thing I am struggling with is going to the next step. I need to know how many patients in a giving time period had 1 appointment, how many had 2 appointments, etc. Then they would like me to create a column graph for the with six columns:

 

1st column for the count of patients with 1 appointment

2nd column for the count of patients with 2 appointments

3rd column for the count of patients with 3 appointments

4th column for the count of patients with 4 appointments

5th column for the count of patients with 5 appointments

6th column for the count of patients with 6 or more appointments 

 

So basically grouping the patients by appointment count, but still slicing by provider and appt date.

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.