Forum Discussion
Adding date column messed up my count
EDIT: I am very new to Power BI and am not a professional coder, so please go easy on me... I have a table visual that lists all procedures performed by my surgeons. I created a slicer with their...
jojo6x It is hard to answer without basic data but I guess you want distinctcount of billing code:
Distinct Billing Code Count =
DISTINCTCOUNT ( YourTable[Billing Code Column] )
That works, but doesn't give me a "Total" column where i can see the count, and when i add the date column to the table visual, it does the same thing as before where it gives me a distinct count of each type per day instead of a total per each type.