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

[yasbos]

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, I need to do a distinct count on values from column cb in the calculated table. 

Relationships:

Table b 1 ---- * Table b

Measure I tried:

var vAcctsTbl=calculatetable(  ADDCOLUMNS(values(b[cb]) ,  "AcctKey", max(a[ca]) ) )

return

Now, here is the problem is that dax doesn't allow me to do

DISTINCTCOUNTNOBLANK(vAcctsTbl[AcctKey])  

Is there any way by which I can accomplish this? Please, note that I don't have the option of creating a physical table because I am working on a live connection to SSAS. Thanks.

[yasbos]

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 · Accepted solution]

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

[foodd]

Please provide your work-in-progress Power BI Desktop file (with sensitive information removed) that covers your issue or question completely in a usable format (not as a screenshot).

https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...

Please show the expected outcome based on the sample data you provided.

https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...

This allows members of the Forum to assess the state of the model, report layer, relationships, and any DAX applied.