Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
HI, everyone,
The following code creates a table. Is there a way to create this table direclty to Report as a visulization Table using any table function?
Thank you.
Dennis
CALCULATETABLE(
Product,
Product[Color] = "Red")
Solved! Go to Solution.
Thank you, it's great helpful for me. Have a good day. Dennis
No, there is no way to manually insert an abitrary table function into a visual. Doing so would make it impossible to integrate with slicers and crossfilters.
For your simple example you could just tick all the columns from the product table and set a filter on Color.
In future you will be able to create a paginated report using the XMLA endpoint if you are on a premium capacity, but that functionality is still just in preview. That way you have full control over the queries, but you lose a lot of the interactive features.
Thank you, it's great helpful for me. Have a good day. Dennis
User | Count |
---|---|
102 | |
91 | |
85 | |
77 | |
71 |
User | Count |
---|---|
113 | |
105 | |
101 | |
75 | |
64 |