Forum Discussion
Column Not Able To Be Added to Visual
I've got a DAX-created table that shows the total number of appts for a given patient ID, summarized from a much bigger table. The summary table consists of 2 columns, PatientID and Number of Appoint...
You have grouped the table based on Patient_ID... so this is dimension not a measure...
In the other hand you want to use it in the chart as measure, which doesnt make sense and obviously PowerBI cannot accept it.
Try to create the table in Power Query editor and then create the chart on desktop
Unfortunately, it is much too large a table (apparently, as it crashes every time I try) to do this in Power Query, hence the DAX workaround.
This is exactly the same setup as in https://radacad.com/customers-grouped-by-count-of-their-orders-static-segmentation-in-power-bi ... so I'm not sure what the difference is that is preventing me from setting up a chart the same way.
