Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to 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
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.
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
@Anonymous , I measure use addolumns and summarize in place of summarize columns
example
Countrows( addolumns( summarize(Fact, Fact[Column], dim[Column]), "_1", [Measure]) )
User | Count |
---|---|
54 | |
23 | |
19 | |
18 | |
17 |
User | Count |
---|---|
91 | |
87 | |
47 | |
28 | |
22 |