Forum Discussion
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...
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.
