Forum Discussion

yasbos's avatar
yasbos
Resolver II
3 years ago
Solved

Count Distinct Values of column in a Calculated Table Variable in DAX Measure

Hi. I have tables a and b. In my measure, I need to create a calculated table consisting of one column from table a (let's call it "ca") and another column from table b, "cb". now, within the measure...
Need Help
  • yasbos's avatar
    yasbos
    3 years ago

    Ok. I used countx...it worked. Thanks.

yasbos's avatar
yasbos
Resolver II
3 years ago

To make the question more generic, can I count the distinct values of a specific column in a calculated table variable in a dax measure? Please, note that the data source is analysis services, so the solution cannot involve creating an actual table.

yasbos's avatar
yasbos
Resolver II
3 years ago

Ok. I used countx...it worked. Thanks.