How do I count the amount of distinct values from a column in a fact table as a calculated measure
Assume the primary key of my fact table is a composite of three columns (a,b,c).
How can I code a calculated measure to count every distinct value of column a, not the amount of rows in my fact table.
Any advise help would be appreciated!
All you need to do is change the measure type from Count to Distinct Count ... make sure you select Column A as your key column....
No comments:
Post a Comment