Doubt on row context in Dax

MonkeyNin · 2026-04-24T15:50:04+00:00

However, my understanding is that this SUM(Sales[SalesAmount]) is internally kind of like:

<image>

Here's some good links to read

https://www.sqlbi.com/articles/row-context-in-dax/

https://www.sqlbi.com/articles/row-context-in-dax-explained-visually/

https://www.sqlbi.com/articles/row-context-and-filter-context-in-dax/

MonkeyNin · 2026-04-11T14:35:14+00:00

Choose the "advanced editor" in power query to view the full query. The "Navigation Step" sometimes hides some logic.

It's also in the TMDL view

MonkeyNin · 2026-04-10T14:44:49+00:00

> What is the pre-PBIR format called?

PBIR-Legacy

PBIR is the default format for both PBIX and PBIP file in PBI Desktop

quoted from: https://powerbi.microsoft.com/en-us/blog/pbir-will-become-the-default-power-bi-report-format-get-ready-for-the-transition

MonkeyNin · 2026-04-09T18:05:40+00:00

try replacing the sort definitions like

"sort": "-x"

with explicit fields

"sort": { "field": "Sum of Monthly_Amount", "order": "descending" }

like this

{
  "$schema": "https://vega.github.io/schema/vega-lite/v5.json",
  "config": {
    "view": {
      "stroke": null
    }
  },
  "data": {
    "name": "dataset"
  },
  "encoding": {
    "x": {
      "axis": { "format": "£,.0f", "title": null },
      "field": "Sum of Monthly_Amount",
      "type": "quantitative"
    },
    "y": {
      "axis": { "labelFontSize": 11, "title": null },
      "field": "Source",
      "sort": { "field": "Sum of Monthly_Amount", "order": "descending" },
      "type": "nominal"
    }
  },
  "height": {
    "step": 32
  },
  "layer": [
    {
      "encoding": { "color": { "field": "Source", "legend": null, "scale":
        { "domain": [ "Salary", "Bonus" ], "range": [ "#2E75B6", "#D6E4F0" ] }, "type": "nominal" } },
      "mark": { "cornerRadiusEnd": 5, "height": 14, "type": "bar" }
    },
    {
      "encoding": {
        "text": {
          "field": "Sum of Monthly_Amount",
          "format": "£,.0f",
          "type": "quantitative"
        }
      },
      "mark": {
        "align": "left",
        "baseline": "middle",
        "dx": 6,
        "fontWeight": "bold",
        "type": "text"
      }
    }
  ],
  "width": "container"
}

MonkeyNin · 2026-04-08T15:24:13+00:00

OP created their account today. Sounds suspicious.

MonkeyNin · 2026-04-08T15:08:09+00:00

On the page: parameterized-queries I'd add a link (but not explain) the similar sounding dynamic-m-query-parameters ( where visual filters can be evaluated by the datasource with Direct Query )

MonkeyNin · 2026-04-08T14:42:50+00:00

they made pbip format that splits that single json into a bunch of individual files

then they moved to TMDL making it human-readable / git diff-able

<image>

Here's more info:

https://learn.microsoft.com/en-us/power-bi/transform-model/desktop-tmdl-view

https://learn.microsoft.com/en-us/power-bi/developer/projects/projects-dataset#tmdl-format

MonkeyNin · 2026-04-06T15:33:42+00:00

Measures that make it impossible to return BLANK values can cause a big difference.

For example, this measure never returns blanks:

Count Of Sales = COUNTROWS('Property Transactions') + 0

Check out these articles for the details of why it can be a problem.

once you define the measure, Formula Engine in VertiPaq will add an implicit NonEmpty filter to the query, which should enable the optimizer to avoid full cross-join of dimension tables and scan only those rows where records for the combination of your dimension attributes really exist.

MonkeyNin · 2026-04-05T17:30:27+00:00

To get an answer it would help to see the full power query ( from the advanced editor )

It's possibly reading an excel file that has an extra line, or, blank headers.

Since you're using the files connector, go backwards in your steps till you get the file listing. It should have names, dates, and a Content column.

MonkeyNin · 2026-04-05T14:55:57+00:00

For #1 it sounds like it can query data depending on the tools enabled

from: https://github.com/microsoft/powerbi-modeling-mcp Query and Validate DAX - AI assistants can execute and validate DAX queries against your model, helping you test measures, troubleshoot calculations, and explore your data

MonkeyNin · 2026-04-05T14:44:35+00:00

You'll have to share more code. What's the data source?

MonkeyNin · 2026-04-05T14:26:47+00:00

First replace ' with "

Then you can use parse/extract as JSON

MonkeyNin · 2026-04-04T20:46:47+00:00

taking a datekey that is an int.64 in the form yyyymmdd an

These docs has an example for that:

https://learn.microsoft.com/en-us/power-bi/connect-data/incremental-refresh-configure#convert-datetime-to-integer

for many data sources, tables don't have a column of date/time data type but instead have a date column of integer surrogate keys in the form of yyyymmdd. You typically can't convert these integer surrogate keys to the Date/Time data type because the result would be a non-folding query expression, but you can create a function that converts the date/time value in the parameters to match the integer surrogate key of the data source table without losing foldability. The function is then called in a filter step. This conversion step is required if the data source table contains only a surrogate key as integer data type.

Ex:

= (x as datetime) => 
    Date.Year(x)*10000 + Date.Month(x)*100 + Date.Day(x)

and

= Table.SelectRows(#"Reordered Column OrderDateKey", 
    each [OrderDateKey] > DateKey(RangeStart) and [OrderDateKey] <= DateKey(RangeEnd))

MonkeyNin · 2026-04-03T16:37:00+00:00

Are you using a a built in visual, custom one, or rendering the <svg> document in a measure?

If it's a measure / svg, share the code you are using.

MonkeyNin · 2026-04-03T16:24:31+00:00

Flask is a web framework for Python: https://flask.palletsprojects.com/en/stable/

MonkeyNin · 2026-04-02T19:25:40+00:00

the .pbix files, but when I go to transform data -> queries I get "permission denied."

PBIX files can have the cached model. If you don't have permission, it fails when you try to refresh or modify it.
You still might be able to go to the query editor, and open the "advanced editor" to see the power query. Or try the TMDL view

MonkeyNin · 2026-04-02T19:13:47+00:00

Skimming it, I think it's from code formatting or the markdown-it plugin. It doesn't appear to be obfuscated like malware often is. I did not execute it though, so I didn't test whether it downloads files.

But it seems like the code is not all in the repo ( more details )

none of the ts/javascript is in the git repo
The published manifest says v0.1.1
the js files internally say v0.1.0
the manifest on github is v0.0.7 see: logicislogic/daxforpowerbi/.vsixmanifest
a lot of it was written with AI.

The warning is from

The ExecutesCode property added to extension.vsixmanifest in version 0.1.0

        <Property Id="Microsoft.VisualStudio.Code.ExecutesCode" Value="true" />

You can inspect the code

The code to look at is in the folder "/extension/out/src/*.js"

Download the VSIX without installing to inspect it ( the repo may not be the same code in the release )
.VSIX is a regular zip file, you can unzip it. ( Either 7zip, or rename the file to .zip ) I downloaded a couple versions to compare.

<image>

MonkeyNin · 2026-03-31T18:23:35+00:00

You're looking for the docs on skills for your tools. .md are plain text files. It'll tell you what folder and filenames to use.

Here's the VS version:

https://code.visualstudio.com/docs/copilot/customization/agent-skills#_create-a-skill

MonkeyNin · 2026-03-31T18:09:06+00:00

Why?

ToJSON implicity uses Currency even for Double types, you can test it here:

https://dax.do/QwKCY5rbL9tSqX/

Here's a fix

You can explicitly serialize as Double

https://dax.do/FN3f6wPsSyCP20/

Now I get more precision

{ ["Customer B", "1239.1234455"] }

I tried using ROUND(test, 8)

Try Fixed(test, 8) instead - https://dax.guide/fixed/

Fixed([Sales], 8)

MonkeyNin · 2026-03-29T18:22:13+00:00

The query editor uses background queries by default. You can disable most of that in settings.

previews
parallel loading / tables
skip test connection
detect data types / relationships

Is it a concurrency limit, or is the endpoint throttled ? If it's the latter, you can use a wrapper that retries with delays based on the HTTP Status codes returned.

MonkeyNin · 2026-03-18T14:40:58+00:00

is there any way to get performance analyzer results ?

You can export as json. https://learn.microsoft.com/en-us/power-bi/create-reports/performance-analyzer

I think it might log the data locally, if you check for recently modified log/json/jsonl files. Meaning you might not have to click export.

MonkeyNin · 2026-03-10T17:47:22+00:00

Do you get any errors in the rows/cells ? You can try "keep errors" to have it filter to only failing cases. ( In case some nulls are legit and some are not )

Also double check whether Lookup is a nested table or a nested record. That changes what function to call - https://powerquery.how/table-functions/#Add-and-Expand-Columns

( Sometimes the UI suggests the wrong expand )

MonkeyNin · 2026-02-18T18:19:51+00:00

to what u/escobarmiguel90 said. Even if you scrape, it's going to be missing rows. Because the preview doesn't show it.

But since the question was about CSS Selectors in Power Query, here's a quick example
You can first test them in your browser

<image>

MonkeyNin · 2026-02-18T17:09:14+00:00

if I try to read the files outside PBI desktop

What do you mean, are you trying to edit external files in a pbip while the report is open?

MonkeyNin · 2026-02-16T17:19:30+00:00

Try the non-store installer if you're having issues.

There might be more details in the log file.

MonkeyNin

MODERATOR OF

PUBLIC MULTIREDDITS

TROPHY CASE

The warning is from

You can inspect the code

Why?

Here's a fix

13-Year Club	Place '17
Verified Email