<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>DAX Commands and Tips topics</title>
    <link>https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/bd-p/DAXCommands</link>
    <description>DAX Commands and Tips topics</description>
    <pubDate>Mon, 16 Nov 2026 05:58:09 GMT</pubDate>
    <dc:creator>DAXCommands</dc:creator>
    <dc:date>2026-11-16T05:58:09Z</dc:date>
    <item>
      <title>Dynamic Top N with an Others bucket: what is the cleanest DAX pattern?</title>
      <link>https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Dynamic-Top-N-with-an-Others-bucket-what-is-the-cleanest-DAX/m-p/5414356#M188734</link>
      <description>&lt;P&gt;I want a visual that shows the top N products by sales, with N chosen in a slicer, and everything else grouped into one Others bar. I have a disconnected TopN table and a measure that uses RANKX over ALLSELECTED(Product[Name]) to return sales only when the rank is within N. For Others I tried total sales minus the sum of the top N, but the numbers go wrong once other slicers are applied. What is the cleanest pattern for the Others bucket?&lt;/P&gt;</description>
      <pubDate>Fri, 13 Nov 2026 00:52:29 GMT</pubDate>
      <guid>https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Dynamic-Top-N-with-an-Others-bucket-what-is-the-cleanest-DAX/m-p/5414356#M188734</guid>
      <dc:creator>jubinsoni</dc:creator>
      <dc:date>2026-11-13T00:52:29Z</dc:date>
    </item>
    <item>
      <title>4-4-5 fiscal calendar: how do you handle time intelligence in DAX?</title>
      <link>https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/4-4-5-fiscal-calendar-how-do-you-handle-time-intelligence-in-DAX/m-p/5410554#M188730</link>
      <description>&lt;P&gt;Hi all,&lt;/P&gt;&lt;P&gt;Our finance team reports on a 4-4-5 fiscal calendar, and the built-in time intelligence functions (SAMEPERIODLASTYEAR, DATESYTD and so on) do not line up with it, especially in 53-week years.&lt;/P&gt;&lt;P&gt;My plan is to put fiscal year, quarter, period, week number and a sequential period index into the date table and write the comparisons against those columns instead. For same week last year I was thinking of something like this:&lt;/P&gt;&lt;LI-CODE lang="dax"&gt;Sales Same Week LY =
VAR _Wk = MAX ( 'Calendar'[FiscalWeekNumber] )
VAR _Yr = MAX ( 'Calendar'[FiscalYear] )
RETURN
    CALCULATE (
        [Total Sales],
        REMOVEFILTERS ( 'Calendar' ),
        'Calendar'[FiscalYear] = _Yr - 1,
        'Calendar'[FiscalWeekNumber] = _Wk
    )&lt;/LI-CODE&gt;&lt;P&gt;Does this hold up in practice? In particular, how do you handle week 53 when comparing to the prior year, and do you generate the calendar in Power Query, DAX or upstream in the warehouse?&lt;/P&gt;&lt;P&gt;Thanks!&lt;/P&gt;</description>
      <pubDate>Wed, 11 Nov 2026 18:45:48 GMT</pubDate>
      <guid>https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/4-4-5-fiscal-calendar-how-do-you-handle-time-intelligence-in-DAX/m-p/5410554#M188730</guid>
      <dc:creator>jubinsoni</dc:creator>
      <dc:date>2026-11-11T18:45:48Z</dc:date>
    </item>
    <item>
      <title>How to highlight the month selected in a slicer without filtering an over-time chart?</title>
      <link>https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-highlight-the-month-selected-in-a-slicer-without/m-p/5408148#M188720</link>
      <description>&lt;P&gt;Hi everyone,&lt;/P&gt;&lt;P&gt;I have a Power BI report with a Snapshot Month slicer used to filter the page to a selected monthly snapshot.&lt;/P&gt;&lt;P&gt;I also have a 100% stacked column chart showing the last 13 monthly snapshots. For this visual, I need to keep all 13 months visible so users can see the trend over time.&lt;/P&gt;&lt;P&gt;What I would like to achieve is:&lt;/P&gt;&lt;UL&gt;&lt;LI&gt;The month selected in the slicer, for example Oct-26, keeps the normal data colors.&lt;/LI&gt;&lt;LI&gt;All other months remain visible but appear faded/lighter.&lt;/LI&gt;&lt;LI&gt;The slicer should continue to filter all the other visuals on the page normally.&lt;/LI&gt;&lt;LI&gt;The over-time chart should not be reduced to only the selected month.&lt;/LI&gt;&lt;/UL&gt;&lt;P&gt;Here is a picture showing the desired result, where Oct-26 is selected and highlighted while the previous months are faded.&lt;/P&gt;&lt;img /&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;BR /&gt;At the moment, if I disable the slicer interaction with the over-time chart, all months remain visible, but the chart no longer seems to have access to the selected month for conditional for&lt;/P&gt;&lt;P&gt;matting. If I enable the interaction, the chart is filtered down to the selected month.&lt;/P&gt;&lt;P&gt;Is there a native way in Power BI to retain the slicer selection context for conditional formatting/highlighting without applying the slicer as a filter to that visual?&lt;/P&gt;&lt;P&gt;Ideally, I would like to avoid creating a disconnected snapshot table and rewriting the existing measures with TREATAS, if there is a simpler approach.&lt;/P&gt;&lt;P&gt;Thanks!&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;</description>
      <pubDate>Tue, 10 Nov 2026 17:42:03 GMT</pubDate>
      <guid>https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-highlight-the-month-selected-in-a-slicer-without/m-p/5408148#M188720</guid>
      <dc:creator>renatofbs86</dc:creator>
      <dc:date>2026-11-10T17:42:03Z</dc:date>
    </item>
    <item>
      <title>Many-to-many with a bridge table: relationship, TREATAS or SUMMARIZE for the best performance?</title>
      <link>https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Many-to-many-with-a-bridge-table-relationship-TREATAS-or/m-p/5408114#M188719</link>
      <description>&lt;P&gt;Hi everyone,&lt;/P&gt;&lt;P&gt;We have products that belong to several categories, modelled with a bridge table between Product and Category. The report needs sales by category, where a product counted in two categories appears in both.&lt;/P&gt;&lt;P&gt;Two measure versions we are comparing look like this:&lt;/P&gt;&lt;LI-CODE lang="dax"&gt;-- A: let the bridge relationships filter the fact table
Sales by Category A =
CALCULATE (
    [Total Sales],
    CROSSFILTER ( Bridge[ProductKey], Product[ProductKey], BOTH )
)

-- B: push the selected categories into product keys with TREATAS
Sales by Category B =
CALCULATE (
    [Total Sales],
    TREATAS ( VALUES ( Bridge[ProductKey] ), Product[ProductKey] )
)&lt;/LI-CODE&gt;&lt;H4&gt;What I would like to hear about&lt;/H4&gt;&lt;UL&gt;&lt;LI&gt;Which of these patterns holds up best when the bridge has millions of rows, and why?&lt;/LI&gt;&lt;LI&gt;When is a native many-to-many relationship a better choice than any DAX approach?&lt;/LI&gt;&lt;LI&gt;How do you avoid double counting in the grand total, and do you show that total at all?&lt;/LI&gt;&lt;/UL&gt;&lt;P&gt;Any benchmark results or DAX Studio observations would be very welcome. Thanks!&lt;/P&gt;</description>
      <pubDate>Tue, 10 Nov 2026 17:29:31 GMT</pubDate>
      <guid>https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Many-to-many-with-a-bridge-table-relationship-TREATAS-or/m-p/5408114#M188719</guid>
      <dc:creator>jubinsoni</dc:creator>
      <dc:date>2026-11-10T17:29:31Z</dc:date>
    </item>
    <item>
      <title>Why Does a Measure Return Different Results in a Table and Matrix Visual?</title>
      <link>https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Why-Does-a-Measure-Return-Different-Results-in-a-Table-and/m-p/5401081#M188705</link>
      <description>&lt;P&gt;Hi,&lt;/P&gt;&lt;P&gt;I have an interesting DAX challenge related to filter context and visual behavior in Power BI Desktop.&lt;/P&gt;&lt;P&gt;Scenario:&lt;/P&gt;&lt;P&gt;Imagine a sales data model containing Sales, Product, Customer, and Date tables.&lt;/P&gt;&lt;P&gt;We create this measure:&lt;/P&gt;&lt;P&gt;Total Sales = SUM(Sales[SalesAmount])&lt;/P&gt;&lt;P&gt;The measure works correctly in a Table visual. However, when using a Matrix with Region &amp;gt; Country &amp;gt; Product Category, some subtotals appear inconsistent with the visible rows when slicers and visual filters are applied.&lt;/P&gt;&lt;OL&gt;&lt;LI&gt;What could cause different results between Table and Matrix visuals using the same DAX measure?&lt;/LI&gt;&lt;LI&gt;How do relationships, filter context, and visual interactions influence subtotal calculations?&lt;/LI&gt;&lt;LI&gt;How would you troubleshoot this using DAX Studio or Performance Analyzer?&lt;/LI&gt;&lt;LI&gt;Would you modify the DAX measure or preserve its original calculation logic?&lt;/LI&gt;&lt;/OL&gt;&lt;P&gt;Important: A simple SUM measure should normally produce additive subtotals for nonoverlapping groups. Unexpected differences require investigation.&lt;/P&gt;&lt;P&gt;I would appreciate hearing how experienced Power BI developers approach this challenge.&lt;/P&gt;&lt;P&gt;Khashayar&lt;/P&gt;</description>
      <pubDate>Sat, 07 Nov 2026 04:34:24 GMT</pubDate>
      <guid>https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Why-Does-a-Measure-Return-Different-Results-in-a-Table-and/m-p/5401081#M188705</guid>
      <dc:creator>Khashayar</dc:creator>
      <dc:date>2026-11-07T04:34:24Z</dc:date>
    </item>
    <item>
      <title>Advanced DAX Optimization: How Do You Improve Performance in Complex Power BI Semantic Models?</title>
      <link>https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Advanced-DAX-Optimization-How-Do-You-Improve-Performance-in/m-p/5395012#M188694</link>
      <description>&lt;P&gt;As Power BI solutions grow, DAX measures can become increasingly complex, especially when working with large datasets, multiple fact tables, complex relationships, and dynamic filter contexts.&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;A report may work perfectly with a small dataset but experience slow visual rendering and high memory consumption when deployed with millions of records.&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;I'd like to understand how experienced Power BI developers approach these challenges.&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;**Some key questions:**&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;1. **DAX Optimization:** How do you optimize complex measures involving nested CALCULATE(), FILTER(), SUMX(), and iterators?&lt;/P&gt;&lt;P&gt;2. **Filter Context:** How do you troubleshoot unexpected results caused by context transition, ALL(), REMOVEFILTERS(), and ALLEXCEPT()?&lt;/P&gt;&lt;P&gt;3. **Model Design:** When should you use a star schema instead of a more complex relationship structure?&lt;/P&gt;&lt;P&gt;4. **Performance Analyzer:** How do you identify whether slow visuals are caused by DAX query execution, model relationships, or storage engine operations?&lt;/P&gt;&lt;P&gt;5. **Large Semantic Models:** What strategies do you use to optimize VertiPaq compression and reduce memory consumption?&lt;/P&gt;&lt;P&gt;6. **DirectQuery vs Import:** How do you decide between Import, DirectQuery, and Direct Lake for large-scale reporting solutions?&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;**My main challenge:**&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Suppose a Power BI report contains 50+ complex DAX measures, multiple fact tables, and more than 20 million rows. Some visuals take 15–20 seconds to load.&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;What systematic approach would you follow to identify bottlenecks and optimize the semantic model without changing the business logic or compromising calculation accuracy?&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;I'd appreciate real-world examples, advanced DAX techniques, and performance optimization best practices.&lt;/P&gt;</description>
      <pubDate>Thu, 05 Nov 2026 05:32:38 GMT</pubDate>
      <guid>https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Advanced-DAX-Optimization-How-Do-You-Improve-Performance-in/m-p/5395012#M188694</guid>
      <dc:creator>binitafulpagare</dc:creator>
      <dc:date>2026-11-05T05:32:38Z</dc:date>
    </item>
    <item>
      <title>Calculation groups vs measure branching with SWITCH: which scales better for time intelligence?</title>
      <link>https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Calculation-groups-vs-measure-branching-with-SWITCH-which-scales/m-p/5393871#M188692</link>
      <description>&lt;P&gt;Hi everyone,&lt;/P&gt;&lt;P&gt;I am reviewing a model where time intelligence is implemented as measure branching, driven by a disconnected selector table:&lt;/P&gt;&lt;LI-CODE lang="dax"&gt;Sales Selected =
VAR _Mode = SELECTEDVALUE ( 'Time Calc'[Mode], "Current" )
RETURN
    SWITCH (
        _Mode,
        "Current", [Sales],
        "YTD", TOTALYTD ( [Sales], 'Date'[Date] ),
        "PY", CALCULATE ( [Sales], SAMEPERIODLASTYEAR ( 'Date'[Date] ) ),
        [Sales]
    )&lt;/LI-CODE&gt;&lt;P&gt;The model has around 40 base measures, so the team is considering moving to calculation groups instead of repeating this pattern per measure.&lt;/P&gt;&lt;H4&gt;What I am trying to decide&lt;/H4&gt;&lt;UL&gt;&lt;LI&gt;Maintainability: one calculation group item versus dozens of SWITCH branches.&lt;/LI&gt;&lt;LI&gt;Performance: whether the storage engine and formula engine behave differently between the two approaches on large fact tables.&lt;/LI&gt;&lt;LI&gt;Gotchas: format strings, precedence between multiple calculation groups, and measures that should not be affected.&lt;/LI&gt;&lt;/UL&gt;&lt;P&gt;For those of you who have migrated, did you see measurable differences in query time or model size, and are there cases where you kept explicit measures on purpose? Any tips on testing the two versions side by side (for example with DAX Studio server timings) would also be appreciated.&lt;/P&gt;&lt;P&gt;Thanks in advance!&lt;/P&gt;</description>
      <pubDate>Wed, 04 Nov 2026 19:02:15 GMT</pubDate>
      <guid>https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Calculation-groups-vs-measure-branching-with-SWITCH-which-scales/m-p/5393871#M188692</guid>
      <dc:creator>jubinsoni</dc:creator>
      <dc:date>2026-11-04T19:02:15Z</dc:date>
    </item>
    <item>
      <title>Best pattern for "same period last year" when the fiscal calendar has 52/53-week years?</title>
      <link>https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Best-pattern-for-quot-same-period-last-year-quot-when-the-fiscal/m-p/5378436#M188683</link>
      <description>&lt;P&gt;Hi everyone,&lt;/P&gt;&lt;P&gt;I'd like to sanity-check the approach for prior-year comparisons on a 4-4-5 retail calendar where some years have 53 weeks. SAMEPERIODLASTYEAR shifts by calendar dates, so week 53 and the first weeks of the next year don't line up.&lt;/P&gt;&lt;P&gt;The pattern I'm considering is a date table with a fiscal week index plus a "prior year week key", and a measure that relies on it instead of time intelligence functions:&lt;/P&gt;&lt;LI-CODE lang="dax"&gt;Sales PY =
VAR _key = SELECTEDVALUE ( 'Date'[PriorYearWeekKey] )
RETURN
    CALCULATE (
        [Sales],
        REMOVEFILTERS ( 'Date' ),
        'Date'[FiscalWeekKey] = _key
    )&lt;/LI-CODE&gt;&lt;P&gt;Questions:&lt;/P&gt;&lt;UL&gt;&lt;LI&gt;Is a precomputed prior-year key the usual way to handle 53-week years, or is there a cleaner approach?&lt;/LI&gt;&lt;LI&gt;How do you treat week 53 when there is no prior-year equivalent: blank, or compare to week 52?&lt;/LI&gt;&lt;LI&gt;Any performance concerns with REMOVEFILTERS on the whole date table versus ALLEXCEPT?&lt;/LI&gt;&lt;/UL&gt;&lt;P&gt;Thanks in advance.&lt;/P&gt;</description>
      <pubDate>Fri, 30 Oct 2026 05:25:17 GMT</pubDate>
      <guid>https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Best-pattern-for-quot-same-period-last-year-quot-when-the-fiscal/m-p/5378436#M188683</guid>
      <dc:creator>jubinsoni</dc:creator>
      <dc:date>2026-10-30T05:25:17Z</dc:date>
    </item>
    <item>
      <title>Calculation groups vs field parameters for time intelligence switching: what has worked for you?</title>
      <link>https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Calculation-groups-vs-field-parameters-for-time-intelligence/m-p/5377658#M188674</link>
      <description>&lt;P&gt;Hi all,&lt;/P&gt;&lt;P&gt;I'm trying to decide between calculation groups and field parameters for letting report users switch time-intelligence views (Current, MTD, QTD, YTD, Prior Year, YoY %) across a set of base measures.&lt;/P&gt;&lt;P&gt;With a calculation group, the items look roughly like this:&lt;/P&gt;&lt;LI-CODE lang="dax"&gt;-- Calculation group: Time Calc
-- Item: YTD
CALCULATE ( SELECTEDMEASURE (), DATESYTD ( 'Date'[Date] ) )

-- Item: YoY %
VAR _cur = SELECTEDMEASURE ()
VAR _py  = CALCULATE ( SELECTEDMEASURE (), SAMEPERIODLASTYEAR ( 'Date'[Date] ) )
RETURN DIVIDE ( _cur - _py, _py )&lt;/LI-CODE&gt;&lt;P&gt;The alternative is a field parameter that lists pre-built measures ([Sales YTD], [Sales PY], [Sales YoY %], ...) which is simpler for report authors but multiplies the number of measures.&lt;/P&gt;&lt;P&gt;A few things I'd like to hear about from people who've run either approach in production:&lt;/P&gt;&lt;OL&gt;&lt;LI&gt;Format strings: is the dynamic format string on the calculation item reliable enough for mixing currency and percentage items in the same visual?&lt;/LI&gt;&lt;LI&gt;Performance: have you seen noticeable differences in query plans or visual load times between the two on larger models?&lt;/LI&gt;&lt;LI&gt;Interaction with other calculation groups (e.g. a currency conversion group) and precedence: any gotchas?&lt;/LI&gt;&lt;LI&gt;Self-service: do business users building their own reports on the shared model find calculation groups confusing in the field list?&lt;/LI&gt;&lt;/OL&gt;&lt;P&gt;Would love to hear what you ended up choosing and why.&lt;/P&gt;&lt;P&gt;Thanks!&lt;/P&gt;</description>
      <pubDate>Tue, 27 Oct 2026 19:36:39 GMT</pubDate>
      <guid>https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Calculation-groups-vs-field-parameters-for-time-intelligence/m-p/5377658#M188674</guid>
      <dc:creator>jubinsoni</dc:creator>
      <dc:date>2026-10-27T19:36:39Z</dc:date>
    </item>
    <item>
      <title>The column 't5.c514'  of the table was not found</title>
      <link>https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/The-column-t5-c514-of-the-table-was-not-found/m-p/5374478#M188650</link>
      <description>&lt;UL&gt;&lt;LI&gt;The error indicates that the t5.c514 column is being referenced during the underlying query/model processing but is not available in the returned result set.&lt;/LI&gt;&lt;LI&gt;Captured the query execution using DAX Studio → Server Timings to identify the underlying SQL generated for the DAX query.&lt;/LI&gt;&lt;LI&gt;Reviewed the SQL generated in Server Timings and validated the SQL statements executed against the backend.&lt;/LI&gt;&lt;LI&gt;No reference to t5.c514 was found in the generated SQL.&lt;/LI&gt;&lt;LI&gt;The generated SQL does not contain a column or alias explicitly referencing t5.c514, even though the Power Query/Mashup error reports that this column is missing.&lt;/LI&gt;&lt;LI&gt;To further isolate the issue, we selected individual columns from the _Employee Assignment Information table and executed separate DAX queries to validate whether the issue was specific to a particular column.&lt;/LI&gt;&lt;LI&gt;But the issue did not occur when selected few particular columns, can someone please help, what exactly the c514 column the engine to mapping to ?&lt;BR /&gt;&lt;BR /&gt;&lt;P&gt;&lt;STRONG&gt;DAX Query:&lt;/STRONG&gt;&lt;/P&gt;&lt;P&gt;EVALUATE&lt;/P&gt;&lt;P&gt;TOPN(100, '_Employee Assignment Information')&lt;/P&gt;&lt;/LI&gt;&lt;/UL&gt;</description>
      <pubDate>Wed, 14 Oct 2026 07:38:15 GMT</pubDate>
      <guid>https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/The-column-t5-c514-of-the-table-was-not-found/m-p/5374478#M188650</guid>
      <dc:creator>mkumarcharla</dc:creator>
      <dc:date>2026-10-14T07:38:15Z</dc:date>
    </item>
    <item>
      <title>Monthly percentage of year amount</title>
      <link>https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Monthly-percentage-of-year-amount/m-p/5374151#M188639</link>
      <description>&lt;P&gt;Please help me with a DAX measure.&amp;nbsp;&lt;BR /&gt;I need to provide the percentage by month of a year amount.&amp;nbsp;&lt;BR /&gt;My matrix visual has Year in rows and Month in columns. I have a Date table that has Months, Quarters, and Year columns.&lt;BR /&gt;This measure that chatGpt came back with isn't working:&lt;/P&gt;&lt;P&gt;DIVIDE( [Orders Taken], CALCULATE( [Orders Taken], REMOVEFILTERS('Date'[Month]) ), 0 )&lt;/P&gt;&lt;P&gt;Please help.&amp;nbsp;&amp;nbsp;&lt;/P&gt;</description>
      <pubDate>Mon, 12 Oct 2026 20:11:41 GMT</pubDate>
      <guid>https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Monthly-percentage-of-year-amount/m-p/5374151#M188639</guid>
      <dc:creator>RobRayborn</dc:creator>
      <dc:date>2026-10-12T20:11:41Z</dc:date>
    </item>
    <item>
      <title>TEXTCONTAINS DAX function not recognized in the latest Power BI Desktop (Import mode)</title>
      <link>https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/TEXTCONTAINS-DAX-function-not-recognized-in-the-latest-Power-BI/m-p/5374021#M188637</link>
      <description>&lt;P&gt;Hi everyone,&lt;/P&gt;&lt;P&gt;I recently updated Power BI Desktop to the latest version and am trying to use the new TEXTCONTAINS DAX function in Import storage mode.&lt;/P&gt;&lt;P&gt;I am using the following measure:&lt;/P&gt;&lt;P&gt;Text Contains Road=&lt;BR /&gt;IF(&lt;BR /&gt;TEXTCONTAINS(&lt;BR /&gt;'SalesLT Product'[Name],&lt;BR /&gt;"Road",&lt;BR /&gt;TEXTMATCHING&lt;BR /&gt;),&lt;BR /&gt;"Yes",&lt;BR /&gt;"No"&lt;BR /&gt;)&lt;/P&gt;&lt;P&gt;However, Power BI returns this error:&lt;/P&gt;&lt;P&gt;Failed to resolve name 'TEXTCONTAINS'. It is not a valid table, variable, or function name.&lt;/P&gt;&lt;P&gt;My model is using Import mode, which is listed as a supported storage mode in the official documentation.&lt;/P&gt;&lt;P&gt;So why i am getting this.&lt;/P&gt;&lt;P&gt;Official documentation: &lt;A href="https://learn.microsoft.com/en-us/dax/textcontains-function-dax" target="_blank"&gt;https://learn.microsoft.com/en-us/dax/textcontains-function-dax&lt;/A&gt;&lt;/P&gt;&lt;P&gt;any resolution is appreciated.&lt;/P&gt;&lt;P&gt;Thank you.&lt;/P&gt;</description>
      <pubDate>Mon, 12 Oct 2026 09:51:45 GMT</pubDate>
      <guid>https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/TEXTCONTAINS-DAX-function-not-recognized-in-the-latest-Power-BI/m-p/5374021#M188637</guid>
      <dc:creator>abhi4</dc:creator>
      <dc:date>2026-10-12T09:51:45Z</dc:date>
    </item>
    <item>
      <title>Count of occrance of Kam from Main table to Second table with selected date range, or month or year.</title>
      <link>https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Count-of-occrance-of-Kam-from-Main-table-to-Second-table-with/m-p/5373805#M188630</link>
      <description>&lt;P&gt;Main Table.&lt;/P&gt;&lt;P&gt;screen shot 1&amp;nbsp;&lt;/P&gt;&lt;img /&gt;&lt;P&gt;screen shot 2&lt;/P&gt;&lt;img /&gt;&lt;P&gt;Second Table&lt;/P&gt;&lt;img /&gt;&lt;P&gt;i want a calculated column in second table in which count of occurance of KAM Name from table Main match with developer name in table second with selected date in table Main.&lt;/P&gt;&lt;P&gt;I want result like below screen shot.&lt;/P&gt;&lt;img /&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;img /&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;</description>
      <pubDate>Sun, 11 Oct 2026 09:20:14 GMT</pubDate>
      <guid>https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Count-of-occrance-of-Kam-from-Main-table-to-Second-table-with/m-p/5373805#M188630</guid>
      <dc:creator>proavinash</dc:creator>
      <dc:date>2026-10-11T09:20:14Z</dc:date>
    </item>
    <item>
      <title>Why does a sorting column affect DAX measures?</title>
      <link>https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Why-does-a-sorting-column-affect-DAX-measures/m-p/5373676#M188627</link>
      <description>&lt;P&gt;I have had this issue happen to me many times over the past few years and I don't understand it, so I was hoping someone else might!&lt;/P&gt;&lt;P&gt;Let's say I have a table of student grades:&lt;/P&gt;&lt;DIV class="styles_lia-table-wrapper__h6Xo9 styles_table-responsive__MW0lN"&gt;&lt;table border="1" style="width: 100%; border-width: 1px;"&gt;&lt;colgroup&gt;&lt;col style="width: 25.0569%" /&gt;&lt;col style="width: 25.0569%" /&gt;&lt;col style="width: 25.0569%" /&gt;&lt;col style="width: 25.0569%" /&gt;&lt;/colgroup&gt;&lt;tbody&gt;&lt;tr&gt;&lt;td&gt;StudentID&lt;/td&gt;&lt;td&gt;Test&lt;/td&gt;&lt;td&gt;Description&lt;/td&gt;&lt;td&gt;Order Sort - From Sort Order Table&lt;/td&gt;&lt;/tr&gt;&lt;tr&gt;&lt;td&gt;1&lt;/td&gt;&lt;td&gt;Test 1&lt;/td&gt;&lt;td&gt;Average&lt;/td&gt;&lt;td&gt;2&lt;/td&gt;&lt;/tr&gt;&lt;tr&gt;&lt;td&gt;1&lt;/td&gt;&lt;td&gt;Test 2&lt;/td&gt;&lt;td&gt;Average&lt;/td&gt;&lt;td&gt;2&lt;/td&gt;&lt;/tr&gt;&lt;tr&gt;&lt;td&gt;1&lt;/td&gt;&lt;td&gt;Test 2&lt;/td&gt;&lt;td&gt;Average&lt;/td&gt;&lt;td&gt;2&lt;/td&gt;&lt;/tr&gt;&lt;tr&gt;&lt;td&gt;2&lt;/td&gt;&lt;td&gt;Test 1&lt;/td&gt;&lt;td&gt;Above Average&lt;/td&gt;&lt;td&gt;1&lt;/td&gt;&lt;/tr&gt;&lt;tr&gt;&lt;td&gt;2&lt;/td&gt;&lt;td&gt;Test 2&lt;/td&gt;&lt;td&gt;Average&lt;/td&gt;&lt;td&gt;2&lt;/td&gt;&lt;/tr&gt;&lt;tr&gt;&lt;td&gt;2&lt;/td&gt;&lt;td&gt;Test 3&lt;/td&gt;&lt;td&gt;Below Average&lt;/td&gt;&lt;td&gt;3&lt;/td&gt;&lt;/tr&gt;&lt;tr&gt;&lt;td&gt;3&lt;/td&gt;&lt;td&gt;Test 1&lt;/td&gt;&lt;td&gt;Average&lt;/td&gt;&lt;td&gt;2&lt;/td&gt;&lt;/tr&gt;&lt;tr&gt;&lt;td&gt;3&lt;/td&gt;&lt;td&gt;Test 2&lt;/td&gt;&lt;td&gt;Below Average&lt;/td&gt;&lt;td&gt;3&lt;/td&gt;&lt;/tr&gt;&lt;tr&gt;&lt;td&gt;3&lt;/td&gt;&lt;td&gt;Test 3&lt;/td&gt;&lt;td&gt;Below Average&lt;/td&gt;&lt;td&gt;3&lt;/td&gt;&lt;/tr&gt;&lt;tr&gt;&lt;td&gt;4&lt;/td&gt;&lt;td&gt;Test 1&lt;/td&gt;&lt;td&gt;Average&lt;/td&gt;&lt;td&gt;2&lt;/td&gt;&lt;/tr&gt;&lt;tr&gt;&lt;td&gt;4&lt;/td&gt;&lt;td&gt;Test 2&lt;/td&gt;&lt;td&gt;Average&lt;/td&gt;&lt;td&gt;2&lt;/td&gt;&lt;/tr&gt;&lt;tr&gt;&lt;td&gt;4&lt;/td&gt;&lt;td&gt;Test 3&lt;/td&gt;&lt;td&gt;Average&lt;/td&gt;&lt;td&gt;2&lt;/td&gt;&lt;/tr&gt;&lt;tr&gt;&lt;td&gt;5&lt;/td&gt;&lt;td&gt;Test 1&lt;/td&gt;&lt;td&gt;Above Average&lt;/td&gt;&lt;td&gt;1&lt;/td&gt;&lt;/tr&gt;&lt;tr&gt;&lt;td&gt;5&lt;/td&gt;&lt;td&gt;Test 2&lt;/td&gt;&lt;td&gt;Above Average&lt;/td&gt;&lt;td&gt;1&lt;/td&gt;&lt;/tr&gt;&lt;tr&gt;&lt;td&gt;5&lt;/td&gt;&lt;td&gt;Test 3&lt;/td&gt;&lt;td&gt;Above Average&lt;/td&gt;&lt;td&gt;1&lt;/td&gt;&lt;/tr&gt;&lt;/tbody&gt;&lt;/table&gt;&lt;/DIV&gt;&lt;P&gt;There is a relationship between the table above and this "Sort Order" table below:&lt;/P&gt;&lt;DIV class="styles_lia-table-wrapper__h6Xo9 styles_table-responsive__MW0lN"&gt;&lt;table border="1" style="width: 100%; border-width: 1px;"&gt;&lt;tbody&gt;&lt;tr&gt;&lt;td&gt;Description&lt;/td&gt;&lt;td&gt;Order Sort&lt;/td&gt;&lt;/tr&gt;&lt;tr&gt;&lt;td&gt;Above Average&lt;/td&gt;&lt;td&gt;1&lt;/td&gt;&lt;/tr&gt;&lt;tr&gt;&lt;td&gt;Average&lt;/td&gt;&lt;td&gt;2&lt;/td&gt;&lt;/tr&gt;&lt;tr&gt;&lt;td&gt;Below Average&lt;/td&gt;&lt;td&gt;3&lt;/td&gt;&lt;/tr&gt;&lt;/tbody&gt;&lt;/table&gt;&lt;/DIV&gt;&lt;P&gt;Next, I have some measures that calculate percentages that &lt;EM&gt;do not involve&amp;nbsp;&lt;/EM&gt;the "Order Sort" column at all. I have charts and matrices that utilize these measures. Everything looks great. However, if I then go into the data view of the first table, select the "Description" column, and sort by the "Order Sort" column, all of my percentages in my charts/matrices change, and they are all incorrect.&lt;/P&gt;&lt;P&gt;I am going crazy and have given up on trying to sort since it ruins my measures!&lt;/P&gt;</description>
      <pubDate>Fri, 09 Oct 2026 13:51:44 GMT</pubDate>
      <guid>https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Why-does-a-sorting-column-affect-DAX-measures/m-p/5373676#M188627</guid>
      <dc:creator>afaherty</dc:creator>
      <dc:date>2026-10-09T13:51:44Z</dc:date>
    </item>
    <item>
      <title>Advice on data and filtering</title>
      <link>https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Advice-on-data-and-filtering/m-p/5373293#M188619</link>
      <description>&lt;P&gt;I have a table with several columns. One column named "Objective" contains various combinations of values from SO1 to SO6 (some have only one of these "SO" values, others have all 6). So I created 6 different columns to allow me to see which records have "SO1" in this column, which have "SO2", and so on up to "SO6". Those records which contain the "SO" values have a "Y" in the new columns.&lt;BR /&gt;&lt;BR /&gt;What I'm trying to do is to filter visuals to show me only the records where there is a "Y" in the corresponding column based on a selection from "SO1" to "SO6" (e.g. selecting "SO2" from a dropdown will show only the records where "Y" is in the new "SO2" column).&lt;BR /&gt;&lt;BR /&gt;I've attached an image of one of the visuals. Any advice on how to achieve this would be appreciated.&lt;BR /&gt;&lt;BR /&gt;Thanks!&lt;/P&gt;&lt;img /&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;</description>
      <pubDate>Thu, 08 Oct 2026 11:15:09 GMT</pubDate>
      <guid>https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Advice-on-data-and-filtering/m-p/5373293#M188619</guid>
      <dc:creator>willfrancis</dc:creator>
      <dc:date>2026-10-08T11:15:09Z</dc:date>
    </item>
    <item>
      <title>Extra Blank Row in Power BI Table Visual After Adding Measures</title>
      <link>https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Extra-Blank-Row-in-Power-BI-Table-Visual-After-Adding-Measures/m-p/5372538#M188593</link>
      <description>&lt;P&gt;Hi everyone,&lt;/P&gt;&lt;P&gt;I have a Power BI model with a &lt;STRONG&gt;Project Milestone&lt;/STRONG&gt; table containing 9 rows (M1–M9). The table has the following columns:&lt;/P&gt;&lt;UL&gt;&lt;LI&gt;Milestone&lt;/LI&gt;&lt;LI&gt;Milestone Name&lt;/LI&gt;&lt;LI&gt;Accomplished&lt;/LI&gt;&lt;/UL&gt;&lt;P&gt;I created these two measures:&lt;/P&gt;&lt;P&gt;ProgressValue = MAX('Project Milestone'[Accomplished]) RemainingValue = 100 - [ProgressValue]&lt;/P&gt;&lt;P&gt;When I add these measures to a table visual along with &lt;STRONG&gt;Milestone&lt;/STRONG&gt; and &lt;STRONG&gt;Milestone Name&lt;/STRONG&gt;, the visual displays &lt;STRONG&gt;10 rows instead of 9&lt;/STRONG&gt;.&lt;/P&gt;&lt;P&gt;The additional row appears at the top with:&lt;/P&gt;&lt;UL&gt;&lt;LI&gt;Milestone: blank&lt;/LI&gt;&lt;LI&gt;Milestone Name: blank&lt;/LI&gt;&lt;LI&gt;ProgressValue: blank&lt;/LI&gt;&lt;LI&gt;RemainingValue: 100&lt;/LI&gt;&lt;/UL&gt;&lt;P&gt;I have checked the source data and confirmed that there are no blank/null values. I also used COUNTROWS('Project Milestone'), which returns &lt;STRONG&gt;9&lt;/STRONG&gt;.&lt;/P&gt;&lt;P&gt;Interestingly, when I remove the measures from the visual, the table correctly displays only the 9 expected rows.&lt;/P&gt;&lt;P&gt;Could someone please explain why this additional blank row is being generated?&lt;/P&gt;&lt;P&gt;Is this related to Power BI's handling of filter context/relationships when evaluating measures, or is there a visual setting that can prevent this row from being displayed?&lt;/P&gt;&lt;P&gt;Thanks!&lt;/P&gt;</description>
      <pubDate>Tue, 06 Oct 2026 05:43:07 GMT</pubDate>
      <guid>https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Extra-Blank-Row-in-Power-BI-Table-Visual-After-Adding-Measures/m-p/5372538#M188593</guid>
      <dc:creator>deepak2002</dc:creator>
      <dc:date>2026-10-06T05:43:07Z</dc:date>
    </item>
    <item>
      <title>Extra Blank Row in Power BI Table Visual After Adding Measures</title>
      <link>https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Extra-Blank-Row-in-Power-BI-Table-Visual-After-Adding-Measures/m-p/5372537#M188592</link>
      <description>&lt;P&gt;I have a multiple tables (Project Milestone, Summary Data, Efforts but there is no relationship with Milestone Tables of both these tables) with 9 rows (M1–M9), each with Milestone, Milestone Name, and Accomplished columns.&lt;/P&gt;&lt;P&gt;I added two measures:&lt;/P&gt;&lt;P&gt;ProgressValue =&amp;nbsp; MAX('Project Milestone'[Accomplished])&lt;/P&gt;&lt;P&gt;RemainingValue = 100 - [ProgressValue]&lt;/P&gt;&lt;P&gt;Once these measures are added to a table visual alongside Milestone and Milestone Name, the visual shows &lt;STRONG&gt;10 rows instead of 9&lt;/STRONG&gt; - an extra row at the top with no Milestone/Milestone Name value, ProgressValue blank, and RemainingValue showing 100.&lt;/P&gt;&lt;P&gt;I confirmed:&lt;/P&gt;&lt;UL&gt;&lt;LI&gt;No blank/null values anywhere in the source data (checked in Power Query and in the Excel source).&lt;/LI&gt;&lt;LI&gt;COUNTROWS('Project Milestone') as a card visual returns &lt;STRONG&gt;9&lt;/STRONG&gt; - confirming only 9 real rows exist in the model.&lt;/LI&gt;&lt;/UL&gt;&lt;P&gt;So the extra row only appears in the table visual, and only after the measures are added - removing the measures makes the table show exactly 9 rows again.&lt;/P&gt;&lt;P&gt;&lt;STRONG&gt;Questions:&lt;/STRONG&gt;&lt;/P&gt;&lt;OL&gt;&lt;LI&gt;Is this a known Power BI behavior where the table visual generates an extra row for reconciliation/aggregation purposes when measures are present?&lt;/LI&gt;&lt;LI&gt;Is there a setting (visual-level or measure-level) to prevent this extra row from rendering, rather than just suppressing its displayed value with an ISBLANK check?&lt;/LI&gt;&lt;/OL&gt;</description>
      <pubDate>Tue, 06 Oct 2026 05:40:02 GMT</pubDate>
      <guid>https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Extra-Blank-Row-in-Power-BI-Table-Visual-After-Adding-Measures/m-p/5372537#M188592</guid>
      <dc:creator>deepak2002</dc:creator>
      <dc:date>2026-10-06T05:40:02Z</dc:date>
    </item>
    <item>
      <title>Power BI matrix header custom formatting</title>
      <link>https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Power-BI-matrix-header-custom-formatting/m-p/5372400#M188588</link>
      <description>&lt;P&gt;I want to apply color coding to a field in the Columns area of a Power BI matrix. Is there a way to create a DAX measure that switches colors based on the value of that Columns field, or some other approach I can take? The UI doesn't allow conditional formatting other than for the Values field. Any alternatives?&lt;/P&gt;</description>
      <pubDate>Mon, 05 Oct 2026 14:36:41 GMT</pubDate>
      <guid>https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Power-BI-matrix-header-custom-formatting/m-p/5372400#M188588</guid>
      <dc:creator>dcohenvogel</dc:creator>
      <dc:date>2026-10-05T14:36:41Z</dc:date>
    </item>
    <item>
      <title>What is wrong with my DAX formula? Using INSCOPE for % of parent and child categories</title>
      <link>https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/What-is-wrong-with-my-DAX-formula-Using-INSCOPE-for-of-parent/m-p/5371975#M188583</link>
      <description>&lt;P&gt;Hello,&lt;/P&gt;&lt;P&gt;In my screenshot below, you can see that I have a 100% stacked bar chart. The first level is great and shows how the students scored (Exemplary, Proficient, Not Provided) on each of the 3 tests. However, when I go to drill down to the next level, which is gender, I am getting 2 different percentages and one is correct while the other is not. I have also included my DAX below. I would appreciate if someone could tell me where I am going wrong. Thanks!&lt;/P&gt;&lt;img /&gt;&lt;P&gt;I'm not sure if this is important to note, but in the above bar charts, the "sex" variable is coming from a separate (but related) table which is Table2. I have a =RELATED column in Table1 with the Sex information (as you can see in my DAX below) but when I put that column into the stacked bar chart, the percentages are even more incorrect. Therefore, the closest to correct that I can get is by placing the "Sex" column from Table2 into the bar chart and the "Sex" column from Table1 into the DAX measure.&lt;/P&gt;&lt;P&gt;Thanks!&lt;/P&gt;&lt;P&gt;My DAX:&lt;/P&gt;&lt;BLOCKQUOTE&gt;&lt;P&gt;%&amp;nbsp; =&lt;/P&gt;&lt;P&gt;VAR CurrentCount = CALCULATE(DISTINCTCOUNT('Table1'[StudentID]))&lt;/P&gt;&lt;P&gt;VAR ParentTotal =&lt;/P&gt;&lt;P&gt;SWITCH(&lt;/P&gt;&lt;P&gt;TRUE(),&lt;/P&gt;&lt;P&gt;ISINSCOPE('Table1'[Sex]), CALCULATE(DISTINCTCOUNT('Table1'[StudentID]), ALLSELECTED('Table1'[Sex])),&lt;/P&gt;&lt;P&gt;CALCULATE(DISTINCTCOUNT('Table1'[StudentID]), ALLSELECTED('Table1'))&lt;/P&gt;&lt;P&gt;)&lt;/P&gt;&lt;P&gt;RETURN DIVIDE(CurrentCount, ParentTotal)&lt;/P&gt;&lt;/BLOCKQUOTE&gt;</description>
      <pubDate>Fri, 02 Oct 2026 18:16:40 GMT</pubDate>
      <guid>https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/What-is-wrong-with-my-DAX-formula-Using-INSCOPE-for-of-parent/m-p/5371975#M188583</guid>
      <dc:creator>afaherty</dc:creator>
      <dc:date>2026-10-02T18:16:40Z</dc:date>
    </item>
    <item>
      <title>Advice on best method to sort - tried many things!</title>
      <link>https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Advice-on-best-method-to-sort-tried-many-things/m-p/5371604#M188576</link>
      <description>&lt;P&gt;Hello. I would love some advice on the best method to custom sort dynamic data. I have a table of students' outcomes on various tests. These outcomes are categorical and change all the time. New tests are added to the data set frequently, as are new outcomes for those tests that already exist. I have tried a SUMMARIZE table, I have tried a reference table, and other methods that I am forgetting at the moment. In any case, I have been unsuccessful. Here is a portion of dummy data from the bigger, complete table of data. The "How I would like to sort" column is what I am attempting to accomplish. My end goal is to have bar graphs/matrices that display the following outcomes in the preferred order shown in the table below. Thank you for your input!&lt;/P&gt;&lt;DIV class="styles_lia-table-wrapper__h6Xo9 styles_table-responsive__MW0lN"&gt;&lt;table border="1" style="width: 100%; border-width: 1px;"&gt;&lt;colgroup&gt;&lt;col style="width: 33.3713%" /&gt;&lt;col style="width: 33.3713%" /&gt;&lt;col style="width: 33.3713%" /&gt;&lt;/colgroup&gt;&lt;tbody&gt;&lt;tr&gt;&lt;td&gt;Test&lt;/td&gt;&lt;td&gt;Outcome&lt;/td&gt;&lt;td&gt;How I would like to sort&lt;/td&gt;&lt;/tr&gt;&lt;tr&gt;&lt;td&gt;Test 1&lt;/td&gt;&lt;td&gt;Proficient&lt;/td&gt;&lt;td&gt;1&lt;/td&gt;&lt;/tr&gt;&lt;tr&gt;&lt;td&gt;Test 1&lt;/td&gt;&lt;td&gt;Exemplary&lt;/td&gt;&lt;td&gt;2&lt;/td&gt;&lt;/tr&gt;&lt;tr&gt;&lt;td&gt;Test 1&lt;/td&gt;&lt;td&gt;Developing&lt;/td&gt;&lt;td&gt;3&lt;/td&gt;&lt;/tr&gt;&lt;tr&gt;&lt;td&gt;Test 1&lt;/td&gt;&lt;td&gt;Not Provided&lt;/td&gt;&lt;td&gt;4&lt;/td&gt;&lt;/tr&gt;&lt;tr&gt;&lt;td&gt;Test 2&lt;/td&gt;&lt;td&gt;Above Proficient&lt;/td&gt;&lt;td&gt;1&lt;/td&gt;&lt;/tr&gt;&lt;tr&gt;&lt;td&gt;Test 2&lt;/td&gt;&lt;td&gt;Proficient&lt;/td&gt;&lt;td&gt;2&lt;/td&gt;&lt;/tr&gt;&lt;tr&gt;&lt;td&gt;Test 2&lt;/td&gt;&lt;td&gt;Below Proficient&lt;/td&gt;&lt;td&gt;3&lt;/td&gt;&lt;/tr&gt;&lt;tr&gt;&lt;td&gt;Test 2&lt;/td&gt;&lt;td&gt;Not Addressed&lt;/td&gt;&lt;td&gt;4&lt;/td&gt;&lt;/tr&gt;&lt;tr&gt;&lt;td&gt;Test 3&lt;/td&gt;&lt;td&gt;Excellent&lt;/td&gt;&lt;td&gt;1&lt;/td&gt;&lt;/tr&gt;&lt;tr&gt;&lt;td&gt;Test 3&lt;/td&gt;&lt;td&gt;Satisfactory&lt;/td&gt;&lt;td&gt;2&lt;/td&gt;&lt;/tr&gt;&lt;tr&gt;&lt;td&gt;Test 3&lt;/td&gt;&lt;td&gt;Needs improvement&lt;/td&gt;&lt;td&gt;3&lt;/td&gt;&lt;/tr&gt;&lt;tr&gt;&lt;td&gt;Test 4&lt;/td&gt;&lt;td&gt;Excellent&lt;/td&gt;&lt;td&gt;1&lt;/td&gt;&lt;/tr&gt;&lt;tr&gt;&lt;td&gt;Test 4&lt;/td&gt;&lt;td&gt;Satisfactory&lt;/td&gt;&lt;td&gt;2&lt;/td&gt;&lt;/tr&gt;&lt;tr&gt;&lt;td&gt;Test 4&lt;/td&gt;&lt;td&gt;Inadequate&lt;/td&gt;&lt;td&gt;3&lt;/td&gt;&lt;/tr&gt;&lt;tr&gt;&lt;td&gt;Test 5&lt;/td&gt;&lt;td&gt;Above Proficient&lt;/td&gt;&lt;td&gt;1&lt;/td&gt;&lt;/tr&gt;&lt;tr&gt;&lt;td&gt;Test 5&lt;/td&gt;&lt;td&gt;Proficient&lt;/td&gt;&lt;td&gt;2&lt;/td&gt;&lt;/tr&gt;&lt;tr&gt;&lt;td&gt;Test 5&lt;/td&gt;&lt;td&gt;Acceptable&lt;/td&gt;&lt;td&gt;3&lt;/td&gt;&lt;/tr&gt;&lt;tr&gt;&lt;td&gt;Test 5&lt;/td&gt;&lt;td&gt;Unacceptable&lt;/td&gt;&lt;td&gt;4&lt;/td&gt;&lt;/tr&gt;&lt;tr&gt;&lt;td&gt;Test 6&lt;/td&gt;&lt;td&gt;Exceeds Expectations&lt;/td&gt;&lt;td&gt;1&lt;/td&gt;&lt;/tr&gt;&lt;tr&gt;&lt;td&gt;Test 6&lt;/td&gt;&lt;td&gt;Meets Expectations&lt;/td&gt;&lt;td&gt;2&lt;/td&gt;&lt;/tr&gt;&lt;tr&gt;&lt;td&gt;Test 6&lt;/td&gt;&lt;td&gt;Below Expectations&lt;/td&gt;&lt;td&gt;3&lt;/td&gt;&lt;/tr&gt;&lt;tr&gt;&lt;td&gt;Test 7&lt;/td&gt;&lt;td&gt;Exemplary&lt;/td&gt;&lt;td&gt;1&lt;/td&gt;&lt;/tr&gt;&lt;tr&gt;&lt;td&gt;Test 7&lt;/td&gt;&lt;td&gt;Acceptable&lt;/td&gt;&lt;td&gt;2&lt;/td&gt;&lt;/tr&gt;&lt;tr&gt;&lt;td&gt;Test 7&lt;/td&gt;&lt;td&gt;Needs Improvement&lt;/td&gt;&lt;td&gt;3&lt;/td&gt;&lt;/tr&gt;&lt;tr&gt;&lt;td&gt;Test 7&lt;/td&gt;&lt;td&gt;Unacceptable&lt;/td&gt;&lt;td&gt;4&lt;/td&gt;&lt;/tr&gt;&lt;/tbody&gt;&lt;/table&gt;&lt;/DIV&gt;</description>
      <pubDate>Thu, 01 Oct 2026 11:43:17 GMT</pubDate>
      <guid>https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Advice-on-best-method-to-sort-tried-many-things/m-p/5371604#M188576</guid>
      <dc:creator>afaherty</dc:creator>
      <dc:date>2026-10-01T11:43:17Z</dc:date>
    </item>
  </channel>
</rss>

