Unable to COUNTROWS of a virtual table using SUMMARIZECOLUMNS

[Anonymous]

Hi Community,

I'm getting a strange error in a measure where I want to count the number of rows in a virtual table.
Note that the measure validates successfully.

The virtual table resolves correctly.

What am I missing?

Cheers, Steve

[v-chenwuz-msft]

Hi @Anonymous ,

SUMMARIZECOLUMNS does not support calculations that occur during contextual transformations, a feature that prevents it from being used in most metrics. You can use it in metrics that call CALCULATE, but you will get an error if you encounter any contextual conversions.

Please refer this article.

https://www.sqlbi.com/articles/introducing-summarizecolumns/ 

As @amitchandak said, try addcolumns() and summarize().

Best Regards

Community Support Team _ chenwu zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous · Accepted solution]

Unfortunately, the CLACULATE didn't resolve the issue.
Also, the solution below doesn't work as I'm trying to identify the gaps in fact data.
I have resolved the issue by creating the combinations in power query rather than DAX.
Everthing is working well.  Thanks for your responses.
Cheers, Steve

[amitchandak]

@Anonymous , I measure use addolumns and summarize in place of summarize columns

example

Countrows( addolumns( summarize(Fact, Fact[Column], dim[Column]), "_1", [Measure]) )