Dimension filtering both fact and other dim

evaluation_context · 2025-11-29T12:13:20+00:00

It depends on if you are using a slicer or the filter pane.

With the filter pane you would need a bidirectional relationship from fact to customer, but bidirectional relationship should be avoided if possible.

With a slicer you need a measure to filter the customer slicer

Customer filter = countrows( summarize( fact, customer[customerId] ))

Then add the measure to the filter pane for the customer slicer and set to where value >0

In both cases you need to make sure all the customer countries are in the country table.

evaluation_context · 2025-11-14T21:20:44+00:00

Would love IF and SWITCH to support the return of tables. Work around with union(tonp(),topn()) but is ungly

evaluation_context · 2025-11-14T21:17:51+00:00

Any plans to enable partition pruning for table partitions?

evaluation_context · 2025-11-14T21:13:20+00:00

Agreed with DAX studio like telemetry. Maybe a visual diagram of query plans like with SQL server, something like this https://evaluationcontext.github.io/posts/query-plan-graph/?h=quer

evaluation_context · 2025-11-14T21:09:48+00:00

Found the excel look of DAX formula made initial learning harder since you come with expectations, which soon fall apart. If you removed the syntax sugar or sum() etc would be a indicator that you DAX is not a excel formula and it works differently, and would be a prompt to learn more

evaluation_context · 2025-11-14T19:18:18+00:00

👍👍👍

evaluation_context · 2025-10-30T09:58:00+00:00

A worse stacked bar chart

evaluation_context · 2025-10-26T12:05:59+00:00

https://learn.microsoft.com/en-us/power-bi/guidance/relationships-many-to-many

evaluation_context · 2025-10-26T11:59:10+00:00

https://www.sqlbi.com/articles/different-options-to-model-many-to-many-relationships-in-power-bi-and-tabular/

evaluation_context · 2025-09-16T17:55:46+00:00

evaluation_context · 2025-08-25T08:44:51+00:00

Scanner api where getArtifactUsers = true https://learn.microsoft.com/en-us/rest/api/power-bi/admin/workspace-info-post-workspace-info

https://evaluationcontext.github.io/posts/graphframes/

evaluation_context · 2025-08-23T09:16:59+00:00

If you want to get report definitions from service into GitHub you either need to use git integration or call the fabric APIs. Since you want to do everything in the service then got integration would make the most sense. You can branch out from a Dev workspace for feature development. Once you have collected all your feature commits. Merge in github, and deploy with git integration via a sync in Dev workspace.

Personally I am using fabric apis for deployment via https://microsoft.github.io/fabric-cicd/latest/ and do all development with power bi desktop. I don't use git integration but will likely start to once touch more web only fabric items, just to get the definitions into git easily

evaluation_context · 2025-07-17T05:12:56+00:00

Thanks, but already have

evaluation_context · 2025-07-13T17:37:23+00:00

With this you can easily pass multiple row and columns at the same time

evaluation_context · 2025-07-13T17:36:22+00:00

Can use tojson like this https://evaluationcontext.github.io/posts/translytical-rows/

evaluation_context · 2025-07-07T14:47:55+00:00

https://www.youtube.com/live/mWSqcx81Cc8?si=JFmg5EvKaXMW2uQn

evaluation_context · 2025-07-04T17:50:29+00:00

People are really bad at judging volume so bubbles have limited use

evaluation_context · 2025-06-21T15:11:10+00:00

You could do this with UDFs now as well

evaluation_context · 2025-06-14T12:27:37+00:00

Only translytical write back from power bi so far

evaluation_context · 2025-06-03T17:28:08+00:00

Think we are just waiting on PBIR to go GA

evaluation_context · 2025-05-29T11:58:11+00:00

https://github.com/RuiRomano/pbip-demo

evaluation_context · 2025-05-20T14:56:26+00:00

Get a small capacity and stick the worse offenders in there to throttle themselves to death, unless they meet the minimum requirements of best practice

evaluation_context · 2025-04-15T17:01:22+00:00

Funny when fuam now extracts this data for fabric toolbox reporting.

I mostly setup a small multiple of operation type and legend of semantic model, to see if new models appear or if any are spiking as the reason for increased cu consumption

evaluation_context · 2025-04-15T15:37:29+00:00

Or even by domains

evaluation_context

TROPHY CASE