Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
@AlexisOlson @parry2k @BernatAgulloMVP
When I create a calculation group, forEach calcculation item in the CG, I need to manually account for conditionalFormatting items (e.g. conditionalFormatting ) as well as any exclusion items (e.g. exclusion for CrossFiltering ) by adding them in each calculatio item in CG. Is there a way to automate that, forEach of m calculation items { n conditional formatting , q exclusion item }.
Thank you in advance.
C# scripts can automate anything you can do manually, so the answer is yes. You might find this session of mine relevant.
https://youtu.be/UWM1RIpAMtk?si=kYyl-X8-nocOs01s
Check also this article of my blog
C# Scripting nirvana: effortlessly use Visual Studio as your coding environment for Tabular Editor C# Scripts | Esbrina https://www.esbrina-ba.com/c-scripting-nirvana-effortlessly-use-visual-studio-as-your-coding-environ...
Not with DAX. But you can automate the creation of calculation groups with a c# script. For many Calc items i rather keep a Calc table with the names of the measures to include. But default the rest are excluded by the transformation
@BernatAgulloMVP sorry for late reply. Is it not possible at all for c# to create each calulation items in a specific way like below?
calCItemOne =
var one = [measure]
var two = conditionalFormt
var three = exclusionTable
return three
The issue that I am facing, that whenver I create a new calculation item in a CG, I need to manually create this. Is there no way to automate this? Would be great if possible.
User | Count |
---|---|
85 | |
77 | |
72 | |
70 | |
55 |
User | Count |
---|---|
106 | |
96 | |
90 | |
79 | |
68 |