i have a fact table like the following
1-episodeKey (not unique)
2-Readmission (takes value null or 'readmission' may i chaneg to (0 or 1) if that help solve the problem)
4-other dimesnions foreign keys
i want to count distinct episode keys where readmission is not null,
so how can i write a calculation that make that count ?
View Complete Post