tabular editor

4 Topics

Building Field Parameters using Tabular Editor 2
Hi all I'm trying to build Field Parameters in Tabular editor 2. As shown here: https://p3adaptive.com/completing-the-set-up-field-parameters-using-tabular-editor/ Issue is that I don't get any columns when I have added the dax code for the calculated table. I'm pretty sure code is correct I've even generated it using desktop and pasted it to be sure.
Solved
Anonymous
2 years ago Place DAX Commands and Tips
5.3KViews
0likes
6Comments
Refer to a Calculated Measure in Tabular Editor inside a Calculation Item Expression
Hi All, Is there a way to refer to a "Calculated Measure" while we write an expression of a "Calculation Item" in Tabular Editor ? I am trying to build a calculation where I need a "Specific Text" to filter one of the columns in the Dates Table. I already built the the required text and stored as a "Calculated Measure" in the Tabular Editor. Is there a way I can use that as filter argument to another Calculation Item? e.g. In my Calculation Group named "TimeCals" "Calculated Measure A" refers to "XYZ" I need to use the above as follows: Calculate( Selectedmeasure(), Removefilters(DatesTable), DatesTable[Column_A]='TimeCalcs'[Calculated Measure A]
Mbuhary_AOud
2 years ago Place DAX Commands and Tips
3.2KViews
0likes
5Comments
Tabular Editor Format String Expression help
Hi. I'm new to Tabular Editor and calculation groups, and I'm wondering if I might get some advice. I have a table containing a dimension that controls dynamic measure selection in my PBIX. It looks like this: IF(ISCROSSFILTERED('Measure Dimensions'[Dimension]), SWITCH(TRUE(), VALUES('Measure Dimensions'[Dimension]) = "Accepted Sum",[Accepted Amount], VALUES('Measure Dimensions'[Dimension]) = "Expected Sum",[Expected Ask Amount], VALUES('Measure Dimensions'[Dimension]) = "Ask Sum",[Ask Amount], VALUES('Measure Dimensions'[Dimension]) = "Accepted Count",[Accepted Ask Count], VALUES('Measure Dimensions'[Dimension]) = "Expected Count",[Expected Ask Count], VALUES('Measure Dimensions'[Dimension]) = "Ask Count",[Asks Made Count], BLANK() ),BLANK() ) I followed some online tutorials to build out a Time Intelligence calculation group in Tabular Editor (TE). One of my takeaways there was that the format set for the calculation items in TE overrides the format set on the measure in the PBIX; this is fine given my current use case. Where I'm at now is setting the format for the SELECTEDMEASURE() based on the name of the selected measure from my measure dimension table. So, if it's a count, the format should be (I think) "0,0;-0,0", and if it's a sum, it should be "$0.00;-$0.00". Can I accomplish this via the Format String Expression in the Expression Editor in TE? If so, do I have to explicitly add the same DAX to the Format Expression for each of my calculation items? Thanks for any tips you can pass long!
Solved
MarkPalmberg
3 years ago Place DAX Commands and Tips
7KViews
0likes
4Comments
Can Tabular Editor 3 read parameter values?
Does anyone know if Tabular Editor is able to read parameter values from the model? I am creating a Power BI model that is made up primarily of parameter values that interact with each other. There are no data tables in the model other than a list of years. I like to write DAX in Tabular Editor but it doesn't seem to read SELECTEDVALUE when I have a slider selection in the model. For example, I have a measures like this: Total Gross Square Feet Value = SELECTEDVALUE ( 'Total Gross Square Feet'[Total Gross Square Feet] , 999) and Cost/SF Level 1 Value = SELECTEDVALUE ( 'Cost/SF Level 1'[Cost/SF Level 1], 100 ) So I write a another measure that multiplies the two together: Cost Level 1 = [Total Gross Square Feet Value] * [Cost/SF Level 1 Value] If I run this in Tabular Editor, and put the result in { }, it does not return a value, but it works fine in PBI. So, I am just wondering if there's a way to get TE to read the parameter values, or if that's not possible. Thanks in advance (BTW, I'm using TE3)
Solved
UBComma
4 years ago Place DAX Commands and Tips
1.3KViews
0likes
2Comments