You want to have this CALCULATE(,Products="Chains") So instead of this CALCULATE(SUM(Sales),Products="Chains") So now imagine that you want to improve the readability of your measures. There are 37 sub categories in Adventure Works, so let’s assume you have 37 measures that all look like this. Total Cap Sales = CALCULATE(SUM(Sales),Products="Caps")
Total Brake Sales = CALCULATE(SUM(Sales),Products="Brakes") Total Chain Sales = CALCULATE(SUM(Sales),Products="Chains") Imagine you have the following measures in the Adventure Works data model. I want to recreate a similar problem (not the same problem) using Adventure Works and share with you the solution I came up with to solve such a problem using Tabular Editor. The same change in every measure that has the same ‘issue’. Long story, short, we decided that he was going to bulk edit a lot of measures to change the way they were written. He has a complex Power BI DAX model with literally hundreds of measures. Without a problem there is little innovation, so I love it when I find a problem that needs to be cracked. But as the saying goes, “necessity is the mother of invention”.
There is definitely some in the Wiki and some more in the Microsoft documentation, but mortal non-programmers like me are simply going to have to work the rest out ourselves, for now at least. One thing that Tabular Editor doesn’t have, however, is a lot of documentation. Daniel Otykier has done a great job with this wonderful bit of software, and the more I use it the more I love it. I like every bit about it, and I am learning more every day. OK, by now you will likely be getting to understand that I think Tabular Editor is pretty cool. Relationships in Power BI and Power Pivot.Who Needs Power Pivot, Power Query and Power BI Anyway?.
Tabular editor 3 cost install#
The Best Way to Install Power BI Desktop.30 Reasons You Should Be Considering Power BI.Dimensional Modeling (Excel and Power BI).Power BI for the Business Analyst (with live Q&A).
0 kommentar(er)
