Automating bulk inclusion of conditional Formatting and exlusion items in CG

[smpa01]

@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.

[BernatAgulloMVP]

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...

[BernatAgulloMVP]

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

[smpa01]

@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.