Given a DAX query - extract all attribute members that are effectively used (not filtered out)

radekceluch — Sat, 01 Jun 2019 14:57:33 GMT

Hi,

I am trying to find a clever way of getting a list of members (values) of a given attribute that are effectively used/analysed in a report. What I do now is I get DAX queries from Azure Monitor and extract memebers with following simplified patterns. However there are many ways to apply filter on attribute.

For now I am looking for following patterns. It works fine for ~95% of DAX queries I get from Azure Monitor. Any ideas how to improve it or extend the list will be highly appreciated. Especially for 2nd pattern which is based on naive assupmption that filters are simple (AND based) and without negations.

Patterns I look for in Kusto currently:

extend X = extractall(@"(?i)TREATAS\s*\(\s*{\s*([^{]+?)\s*}\s*,\s*'Table'\[Attribute]", TextData_s)
extend Y = extractall(@"(?i)'Table'\[Attribute]\s*IN\s*{\s*([^{]+?)\s*}", TextData_s)

My ask is if you know of any way/tool/anything to cope with this task or if anyone had similar problem and how (s)he managed to solve it?

Thank you very much for any ideas, insights and help!

Regards,

Radek Celuch

topic Given a DAX query - extract all attribute members that are effectively used (not filtered out) in DAX Commands and Tips

Given a DAX query - extract all attribute members that are effectively used (not filtered out)