DAX Commands and Tips topics

Distance-Based Location Highlighting

Swami_om — Fri, 18 Sep 2026 15:28:14 GMT

Hello,

I’m trying to calculate the distance between the assigned location and the employee’s home location using the latitude and longitude available in this file.

The objective is to identify locations that are within the selected distance range (in kilometres) using a kilometre slicer. I would like the locations that fall within the selected range to be highlighted in green, while all other locations remain grey.

Additionally, I would like the selected location to be highlighted based on the selected City, Employee Location, or StoresDummy[City] value.

I’ve also referred to the following YouTube video for guidance: youtube

Could you please help me implement this logic in Power BI/DAX?

Sample data

Showing working day no instead of calendar

Nicpet0 — Thu, 17 Sep 2026 09:37:38 GMT

Hello,

i am facing a challenge where i want to have a bar chart showing daily invoiced sales, but instead of showing calendat day no number on x-axis i want to replace it with working day no.

Data model setup:

Base model: Tabular (storage mode: mixed)
tables and dimensions used:
'Calendar'[ID] - linked to transaction table through a many to one relationship
'Calendar'[day no] - this is what i currently use on my x-axis. This is simply showing day number 1-30 depending on the selected fiscal year and fiscal month
'Calendar'[Fiscal Year] - used in dropdown to filter on fiscal year. runs from 1 july - 30 june
'Calendar'[Fiscal Month] - used in dropdown to filter on fiscal month. runs from 1 july - 30 june
'Global Measures'[Invoiced Amount]

Requirements:
Create a field to the calendar table return Working day no depending on the selected fiscal year and month. Working day counts as monday-friday, weekends is NOT a working day. Also public holidays should also not be taken into account. Working day should start counting from the first weekday of the filtered month and start over when a new month begins. Ideally, when using the field on the visual, weekends should be blank. I have tried to illustrate my idea through the snapshot below. The grey bars represent saturday and sunday to clearly distinct weekdays and weekends.

So far i havent been able to find a working solution, so i am trying my luck making a post here. If there is any information needed regarding the data model or relationships etc. i will try to elaborate, just let me know.

Using LookUpValue

greenda4 — Wed, 16 Sep 2026 17:53:13 GMT

Hi,

I created a calculated column and trying to use the LookUpValue function and am receiving the following error

Underlying Error: DataViewMappingError_ConditionNotHierarchicallyRelated

Activity ID: 77181316-2e02-44ea-b104-201ac8d72366

Also, I am getting an error on my visual saying "You are using fields that don't have a supported set of relationships". Not seeing the issue as I have used this LookUpValue function before.

Help! explain this measure and why it isn't working consistently!!

aallman — Wed, 09 Sep 2026 20:11:50 GMT

I have a report that someone else made and they are not seeing some data show in the visuals that they would expect to see. After investigating I found out that the measures are behaving strangely.

Basically there are 3 measures. One determines if there are any items on a SalesOrder that have a synthesisDepartment of "LEU Main - Tubes" :

HasLEUMainTubes = VAR CurrentSalesOrder = MAX('vwOperationsBacklog'[SalesOrder]) RETURN CALCULATE ( COUNTROWS ( 'vwOperationsBacklog' ), 'vwOperationsBacklog'[SalesOrder] = CurrentSalesOrder, 'vwOperationsBacklog'[SynthesisDepartment] = "LEU Main - Tubes" )

One determines if there are any items on a SalesOrder that have a synthesisDepartment of "LEU Platinum" :

HasLEUPlatinum = VAR CurrentSalesOrder = MAX('vwOperationsBacklog'[SalesOrder]) RETURN CALCULATE ( COUNTROWS ( 'vwOperationsBacklog' ), 'vwOperationsBacklog'[SalesOrder] = CurrentSalesOrder, 'vwOperationsBacklog'[SynthesisDepartment] = "LEU Platinum" )

And the third measure determines if the SalesOrder has items from both departments:

HasBothLEUMainTubesAndPlatinum =IF ( [HasLEUMainTubes] > 0 && [HasLEUPlatinum] > 0, 1, 0)

The visual is a table that displays a list of SalesOrders that have both Main and Platinum items. However, the users only want to see $ values and specific products that are from Main and have applied a visual level filter of Synthesis Department = "LEU Main - Tubes".

Here is the issue: In most cases, this works out fine. Example order 9558544 which has 8 items in each of the two departments shows up in my main visual with only $ associated to the Main department. BUT example order 21583399 does NOT show up in the table even though it has 2 Platinum items and 3 Main items.

example of main visual displaying order 9558544 as expected with SynthesisDept filter set to LEU Main - Tubes

I created a quick look at these 2 orders and the results of the 3 measures below (separated by Synth Dept)

As soon as I apply a visual level filter to that same table (setting Dept = Leu Main - Tubes), this is the result:

WHY DOES ONE ORDER WORK DIFFERENTLY FROM THE OTHER?????

I also know I could probably come up with a better way of doing this (I did not develop these measures, a user did) but I ultimately want to know why it functions like this.

( DAX Condicional )Definir Ancho (Px) de una Matriz

AldahirGóngoraP — Mon, 07 Sep 2026 23:34:32 GMT

¡Hola comunidad!

Estoy probando la nueva función de control dinámico de ancho de columnas (fx) de la actualización de agosto en Power BI, pero tengo problemas al aplicarla en una Matriz con 3 niveles de jerarquía en columnas.Mi objetivo es que la columna llamada "|" (ubicada en el tercer nivel) tenga un ancho de 10 Px, y todas las demás columnas tengan 100 Px.

He intentado condicionar el ancho con medidas DAX usando funciones de contexto (como ISINSCOPE), pero la matriz no reacciona en el tercer nivel y la condicional se ignora. Parece que la propiedad de ancho dinámico evalúa a nivel global o del campo principal, perdiendo el contexto en subniveles profundos.

¿Alguien ha logrado hacer funcionar el formato condicional de ancho en un tercer nivel de jerarquía? ¿Existe alguna limitación documentada o algún workaround eficiente que no requiera ajustar el tamaño manualmente?¡Agradezco su ayuda!

Performance / Size implications of BLANK() vs 0

Devs — Mon, 07 Sep 2026 14:19:04 GMT

Hello everyone,

I have a question concerning how BLANKS are handled in Semantic models.

I have a DAX table that I'm creating using UNION and select tables (Yes, I have to do it in DAX and not in M).

In some cases, my the columns in my "Selectcolumns" need to be empty or set to 0 (Double).

Is there an reason to choose one over the other ?

From what I understand from this article :

https://www.sqlbi.com/articles/blank-handling-in-dax/

Both 0 and Blank seem to be handled the same way; as in "BLANK" is converted to 0 during compute.

By using Blank I thought there would be less memory usage, but I don't really see it.

In fact, when I use the VertipackAnalyser in DAX Studio, sometimes leaving a column full of 0 is better than putting blanks everywhere.

Is BLANK() stored differently than 0.0 in a semantic model ?

In a SUM, are BLANK rows skipped, or are they still converted to 0 ?

Has someone ever done the experiment ?

At which point does this question really start to matter ?

Last 3 months calculation not working

chlimaye — Fri, 04 Sep 2026 17:53:48 GMT

Hi Team,

I am working on logic for last 3 months logic. after SKU all are measures.

"V4Cast ESF WD9 Lag3" is forecast and actual detail table is actual.

"DVMI_Forecast_error" is Forecast - Actuals.

"DVMI_Forecast_error_ABS" is Absolute value of DVMI_Forecast_error.

"Total Last 3 Months" non absolute Last 3 months calculation of every month for DVMI_Forecast_error and its working accurate.

when i apply same logic on "ABS Total Last 3 Months" by using "DVMI_Forecast_error_ABS" its not working.

logic used

ABS Total Last 3 Months =

CALCULATE(

[DVMI_Forecast_Error_ABS],

DATESINPERIOD(

'DimDate'[Date],

LASTDATE('DimDate'[Date]),

-3,

MONTH

)

% calculations in a matrix

Dunnes32 — Thu, 03 Sep 2026 16:21:37 GMT

Good afternoon ,

I wonder if someone could help me with a DAX query i am having issues with to show the % of parent at two levels.

I can get the calculations to work individually but when i put them both together (% Combined) the top level % is all showing 100%

M_referrals is a count of rows in the table used

% of parent group = var ParentTotal = CALCULATE( [M_Referrals], Allexcept(Referral,Referral[OUTCOME_DURATION_GROUP]) ) return if( ISINSCOPE(Referral[REFERRAL_SLA_GROUP]), DIVIDE([M_Referrals],ParentTotal) )

% of parent SLA group = var ParentTotal = CALCULATE( [M_Referrals], Allexcept(Referral,Referral[REFERRAL_SLA_GROUP]) ) return if( ISINSCOPE(Referral[OUTCOME_DURATION_GROUP]), DIVIDE([M_Referrals],ParentTotal) )

% Combined = var ParentTotal = CALCULATE( [M_Referrals], Allexcept(Referral,Referral[REFERRAL_SLA_GROUP]) ) var SubCat_Total = CALCULATE( [M_Referrals], Allexcept(Referral,Referral[OUTCOME_DURATION_GROUP]) ) var RatioToParent = if( ISINSCOPE(Referral[REFERRAL_SLA_GROUP]), divide([M_Referrals],ParentTotal), if( ISINSCOPE(Referral[OUTCOME_DURATION_GROUP]), divide([M_Referrals],SubCat_Total) ) ) Return RatioToParent

If anyone could point me in the right direction that would be great.

My Next issue will also be to add a Month into the columns, if you could give some advice on this that would be great too thanks

Weight in survey data

Kathrinens — Thu, 27 Aug 2026 12:26:30 GMT

I have a large amount of data from two surveys and i'm struggling with calculating certain percentages. I've tried to simplify it a lot here, but it does require a long setup.

In the data every respondent has been given an individual weight, so that for instant respondents in an age group with few respondents might count for a bit more than those in other age groups. Therefor in a given answer, it is not number of respondents but the sum of their weight that's the relevant.
The table for respondents look something like this, but with many more columns.:

'Respondents'

ID	Age	Weight
1	55	0,7
2	17	1,2
3	21	1,1

For quite a few questions the respondents could answer by choosing several options for instance "Which of the following options are you familiar with: A, B, C...". This give a tabel like:

ID	Uses A	Uses B	Uses C
1	0	1	1
2	0	0	0
3	1	0	1

The only way I can count those replies is by copying the table, remove unnecessary columns and unpivot columns A, B, C, so I get the following table which is related to the respondent tabel by ID:

'Q1_Options' tabel

ID	Uses	Weight
1	B	0,9
1	C	0,9
3	A	1,3
3	C	1,3

However, not all respondents have been asked all questions. So when calculating how many percentage answered yes to an option, the sum of weight of those answers should be held op against the collected weight of only those respondents, that have been asked the question.

In the example here the weight of for instance option A is 1,3.
The collective weight of the respondents who have been askes the question (ID 1 and 3) is 1,8
1,3 / 1,8 = 72%

But how do I write a dax query that can calculate the collective sum of only those who replied and where their weight is only counted once, but also is resistant to filters and rows so if can be used in the calculation of percentage?

My best guess so far is this, which doesn't work:

CALCULATE( SUM('Respondents'[weight], TREATAS( VALUES('Q1_Options'[ID]), Respondents[ID] ) ,ALL('Options-table') )

It does return the right total, but when I put it in a matix it just calculates the weight of the answers, and therefor the percentage just returns 100% on all. I've also tried with REMOVEFILTERS with no difference.

Help with DAX

Lio123 — Thu, 27 Aug 2026 12:10:16 GMT

Dear Pros,

Need help here

I have a monthly recurring charge (MRC) from multiple customers that continues every month until the end of their contracts. I want to calculate the MRC amount for each month. For example, Customer A starts billing in January and pays $100 every month until the contract ends, while Customer B starts billing in March and pays $50 every month until the end of the contract.

So I want see how much money we have received every month and from which customers.
Something like this
Jan - 100
Feb - 100
Mar - 100+50
Apr - 100+50
.... so on

Note : I don't have the end of the MRC month date but I have the start of the MRC billing and number of billable months in each year

please help with dax

Power BI DAX Challenge – ALLSELECTED vs Correct Grand Total

aayushianand97 — Thu, 27 Aug 2026 02:14:26 GMT

I have a fact table with sales document and other columns.

For reporting purposes, I need to display the total Sales Order Weight at the Sales Document level, so I use ALLSELECTED() to ignore the other row context while still respecting report slicers.

Current requirement

Suppose the raw data is:

Sales Document

Item

Bill of Lading

Weight

SO1

BOL1

600

SO1

BOL2

594

I need my report to show:

Sales Document

Bill of Lading

Sales Order Weight

SO1

BOL1

1194

SO1

BOL2

1194

The repeated value is intentional.

Slicer requirement

If the user filters Classification, Material, Delivery, Plant, etc., the measure must respect those slicers.

Example:

If only Item 10 remains after a slicer, the measure should return 600, not 1194.

This is why I'm using ALLSELECTED() instead of REMOVEFILTERS().

The problem

The row values are correct, but the Grand Total is incorrect because the repeated Sales Document weight gets summed multiple times.

The expected total is:

1194

but Power BI returns:

1194 + 1194 = 2388

(or similar duplication depending on the number of Bill of Lading rows).

Current measure (simplified)

CALCULATE(

SUM('Sales&Delivery'[Sales Order Weight of the Item in Grams]),

'Sales&Delivery'[Delivery] <> BLANK(),ALLSELECTED('Sales&Delivery'[BillOfLadingDrvd]),

ALLSELECTED('Sales&Delivery'[Delivery]),

ALLSELECTED('Sales&Delivery'[Default Plant]),

ALLSELECTED('Sales&Delivery'[PlantDelivery]),

ALLSELECTED('Sales&Delivery'[ActualGoodsMovementDate]),

ALLSELECTED('Sales&Delivery'[Classification])

)

Things I've already tried

SUMX(VALUES(SalesDocument), ...)

SUMMARIZE()

ALLEXCEPT()

KEEPFILTERS()

TREATAS()

Calculated column approach

Visual Calculations

None of them satisfy all three requirements simultaneously.

Question

How can I write a DAX measure that:

Repeats the Sales Order Weight for every belonging to the same Sales Document.

Respects all report slicers (Material, Classification, Delivery, Plant, etc.).

Produces a Grand Total that counts each Sales Document only once instead of summing the repeated values.

Is there a DAX pattern for this?

SUMX Not Working

ronnie_roberts — Thu, 20 Aug 2026 15:48:11 GMT

I have created a sample dashboard based on the AdventureWorks sample database and I cannot figure out why I cannot get this to work. I can evaluate every VAR throughout except _Result which never works. I have attached a photo of _FilteredTable, which you can see is a very simple table with a total.

(the code snippet is showing up incorrectly, so I've also included a screenshot of the fairly simple code)

DEFINE VAR _TableWithBadNames = SUMMARIZECOLUMNS ( 'Production ProductCategory'[Name], 'Sales SalesOrderHeader'[OrderDate].[Year], "@Total", SUM('Sales SalesOrderDetail'[LineTotal]) ) VAR _Table = SELECTCOLUMNS( _TableWithBadNames, "@Category", [Name], "@Year", [Year], [@Total] ) VAR _FilteredTable = FILTER(_Table, [@Category]="Accessories" && [@Year]=2011) VAR _Result = SUMX(_FilteredTable, [@Total]) EVALUATE _Result

How to compare static table to updated table, find rows that changed?

Cayshin — Fri, 21 Aug 2026 13:37:42 GMT

At the start of each month, I take a snapshot (TABLE1) of a live data table (TABLE2). TABLE2 has three relevant columns that defines a unique row (Title, Amount, Salesperson), and a fourth column that can change (Date):

Title

Amount

Salesperson

Date

The snapshot also adds a "Snapshot date" column. it's relevant headers look like:

Title

Amount

Salesperson

Date

Snapshot Date

There's a table visual to display these snapshot items and a Year, Month slicer (Relationship: CalenderTable[Date] -> TABLE1[Snapshot Date]) to filter the snapshots to only a specific month.

I now want to compare these snapshot items to the live data table and have the table visual only show rows where the Date column changed to a later date.

After some googling, I created a Measure I can use to filter the table visual to values of "1", but the date comparison doesn't seem to be working right. It's returning some rows where the Date in TABLE2 was changed to earlier (we don't care about those) than the Date in TABLE1 and I can't figure out why.

Rolled = If( COUNTROWS( CALCULATETABLE(TABLE2 , TABLE2[Name] = SELECTEDVALUE(TABLE1[Name]) && TABLE2[Amount] = SELECTEDVALUE(TABLE1[Amount]) && TABLE2[Salesperson] = SELECTEDVALUE(TABLE1[Salesperson]) && TABLE2[Date] > SELECTEDVALUE(CalendarTable[Date]) ) ) > 0, 1, 0 )

Example of wrongly listed TABLE1 row:

TABLE2 is not connected by any relationships. I manually applied filters to show the same row to see if the measure worked properly.

What am I doing wrong or is there a better way to do this?

Help with DAX and report level filters

jslade — Mon, 17 Aug 2026 23:03:40 GMT

I need to convert the below dax formula to ignore the report level filter of DimSeller[SalesId] but honor the visual level filter of DimSeller[Sales NSAA Region].

Reservations = var selection = SELECTEDVALUE(DateSelect[SelectId])
RETURN
SWITCH(true(),
selection = 1, CALCULATE(FactReservation[Res By Res Date]),
selection = 2, CALCULATE(FactReservation[Res By Check In Date]))

I've tried

Reservations = var selection = SELECTEDVALUE(DateSelect[SelectId])
RETURN
SWITCH(true(),
selection = 1, CALCULATE(FactReservation[Res By Res Date], All(DimSeller[Salesid]), KEEPFILTERS(DimSeller[Sales NSAA Region]).... with no luck.

I've also tried creating a second table for the Sales NSAA Region values and using it as the visual level filter but still have not been able to get it ignore the report level filter and keep the visual level filter. The only way I've gotten to work is creating a measure that hardcodes the DimSeller[Sales NSAA Region to the value. However, if I go this route I'll have to create 48 measures so hoping there is a way to get a single measure to work.

Comparaison de courbes en S par jalon et par quarter — Quelle architecture DAX ?

Wanou — Fri, 14 Aug 2026 12:49:10 GMT

Bonjour à tous,

Je travaille sur un rapport Power BI de suivi de production et j'aimerais avoir vos conseils sur l'architecture à adopter.

Contexte

Je suis en train de construire des courbes en S cumulatives qui mesurent, jour après jour, le pourcentage de SKU-SITE ayant atteint un jalon de production donné. Disons que les jalons suivis sont : Jalon1, Jalon2, Jalon3. Les données sont organisées par quarters : 24Q1, 25Q1, 26Q1, etc.

Mon modèle de données est le suivant :

Dim_SKU (one) → Fact_SKU-SITE (many) par le code SKU (Dim_SKU stock les infos de mes skus, la fact sku-site m'apporte une combinaison entre un sku et site de production (pk) car un sku peut se retrouver dans plusieurs site de production)
Une table disconnected Axe X Courbes S utilisée comme axe X, reliée à Fact_SKU-SITE via des relations inactives activées par USERELATIONSHIP. La timeline se calcule comme cela : Date Event (un évènement important pour le début de la prod) -> JalonX (en jours), chaque timeline a donc une relation inactive avec ma table X courbes S [value]

Ce que je veux obtenir

Afficher sur un même graphique en courbes, plusieurs séries superposées correspondant à des combinaisons librement choisies, par exemple : Jalon1 26Q1, Jalon1 25Q1, Jalon2 26Q1, etc. L'idéal serait de pouvoir sélectionner les combinaisons à afficher via des slicers.

Ce que j'ai déjà

Une mesure fonctionnelle par combinaison jalon × quarter, construite ainsi :

% Courbe S Event > Jalon1 26Q1 =
VAR Jour = SELECTEDVALUE('Axe X Courbes S'[Value])
VAR Numerateur =
    CALCULATE(
        DISTINCTCOUNT('Fact_SKU-SITE'[PK_SKU_x_Site]),
        USERELATIONSHIP('Axe X Courbes S'[Value], 'Fact_SKU-SITE'[Event > Jalon1 (jrs)]),
        FILTER(ALL('Axe X Courbes S'), 'Axe X Courbes S'[Value] <= Jour),
        'Fact_SKU-SITE'[Jalon1 Statut A/B] = "A",
        NOT(ISBLANK('Fact_SKU-SITE'[Event > Jalon1 (jrs)])),
        KEEPFILTERS(FILTER(ALL('Dim_SKU'), 'Dim_SKU'[SKU Quarter (pour filtre)] = "26Q1"))
    )
VAR Denominateur =
    CALCULATE(
        [NB SKU-SITE],
        KEEPFILTERS(FILTER(ALL('Dim_SKU'), 'Dim_SKU'[SKU Quarter (pour filtre)] = "26Q1"))
    )
RETURN
    DIVIDE(Numerateur, Denominateur)

Le problème

Pour afficher N courbes superposées sur un même graphique, Power BI nécessite N mesures distinctes dans le puits Valeurs. Avec 3 jalons × 4 quarters, cela représente déjà 12 mesures. Le nombre va croître avec les quarters.

L'IA m'a envisagé une architecture avec :

1 mesure métier par jalon contenant toute la logique
1 wrapper one-liner par combinaison appelant la mesure métier avec le quarter forcé

Mais je me demande s'il existe une approche plus élégante, notamment via Field Parameters, Calculation Groups, ou toute autre technique qui permettrait de réduire le nombre de mesures tout en conservant la possibilité d'afficher plusieurs courbes superposées de différent jalons et différent quarter sur un même graphique.

Merci d'avance pour vos retours !

Désolé pour la longueur du post, mais j'ai préféré ajouter plus de contexte que pas assez

Need DAX measure to show yearly DISTINCTCOUNT per Group instead of aggregated total

luzrueda — Fri, 07 Aug 2026 13:33:53 GMT

Dear Community,

I want to adjust my measure so that it always returns the correct count per “ID Group”, and it should correctly respect the filters for Company and Date/Year.

Right now, my formula sums all years together. It does not break the values down by the selected year (Screenshot at the end)

What I need

For each Group Name, I want the measure to show the correct yearly count, and this value should be repeated for all its subcategories (Rubrik Name).

Example

For the group “1. Arbeitssicherheit”, I should get:

2024: instead of showing 18 for all subcategories, the measure should show 5
2025: instead of 18, it should show 9
2026: instead of 18, it should show 4

For the group “2. Umweltschutz”, I should get:

2024: instead of 6, it should show 1
2025: instead of 6, it should show 3
2026: instead of 6, it should show 2

Current Measure (returns total across all years)

Group =
CALCULATE(
DISTINCTCOUNT('Kontrollen_Kriterien (1)'[pageAddress]),
ALLSELECTED('Kontrollen_Kriterien (1)'),
REMOVEFILTERS('Kontrollen_Kriterien (1)'[Rubrik Name]),
KEEPFILTERS(VALUES('Kontrollen_Kriterien (1)'[Gruppe Name]))
)

This measure correctly removes the subcategory filter, but it still aggregates all years together. I need a version that keeps the selected Year filter active, so the count is calculated per year and per group. My Year is comming from a Data Table joining my Table thorugh the colum "Final Date".

Thank you so much for your help, finding a proper formula for this.

How to create a measure to calculate incremental value between two cases in same table

drogzy — Fri, 07 Aug 2026 05:03:06 GMT

Would appreciate any helping in creating a DAX measure to calculate incremental values (filtered to Steam Rate m3/d for this exercise) between different cases over time. I would prefer the formula to always use a reference case (in this case it would be "PAD111_DN) so that I can have a slicer which would allow me to switch between different cases while the calculation still uses that case as a reference.

Also want to show it in a chart where the x-axis would be Date

Thank you

Counting distinct list against multiple contain strings

Peterdown — Fri, 07 Aug 2026 01:40:15 GMT

Looking for some assistance. I'm a novice 🙂

I need to count instruments within a set of specific types and for a specific financial year IF they have also have a specific set of offences listed. The offences are concatenated into a single list. An instrument (as represented by an instrument number, e.g. K010200) may have more than one of these offences but I only want to count an instrument once.

I thought the approach I finally landed on worked. But... it double counts if an instrument matches against more than one of the legislation references. I have 49 measure in total - some only have 1 reference to match against while several have 7.

*Please note the legislation references and instrument types shown below are publically available within our differing sets of legislation so I am not sharing any content that breaches any level of security etc.

MEASUREA1=

VAR A = CALCULATE(

DISTINCTCOUNT('prod extract'[instrument_number]),

left('prod extract'[instrument_type],3) in {"s46","s48"},

'prod extract'[issued_date_financial_year] in VALUES(refdata[current_year]),

CONTAINSSTRINGEXACT('prod extract'[offence_list],"5D(1)(c)") +0)

VAR B = CALCULATE(

DISTINCTCOUNT('prod extract'[instrument_number]),

left('prod extract'[instrument_type],3) in {"s46","s48"},

'prod extract'[issued_date_financial_year] in VALUES(refdata[current_year]),

CONTAINSSTRINGEXACT('prod extract'[offence_list],"5D(5A)")+0)

VAR C = CALCULATE(

DISTINCTCOUNT('prod extract'[instrument_number]),

left('prod extract'[instrument_type],3) in {"s46","s48"},

'prod extract'[issued_date_financial_year] in VALUES(refdata[current_year]),

CONTAINSSTRINGEXACT('prod extract'[offence_list],"5D(2)(a)(b)(iv)") +0)

RETURN

A+B+C

Divide in Power BI

Mark_Vdc — Thu, 06 Aug 2026 11:49:58 GMT

Hi! I'm rather new with Power BI so probably this is a stupid question but I can't find the answer.

I have two tables:

1) Calculation of total of used storage per network (which is a table "Pivot werkingskosten" I added in power BI)

2) Uploaded table 'budgetten' which is the maximum storage per network.

My question: how do i calculate (in a new table) the usage of the storage per network?

I tried with this: Usage budget = divide(SUM('Pivot werkingskosten'[totaal]),sum(Budgetten[Budget Werkingskosten])) but that does not seem to work...

Any suggestions?

Erro em Calculate com múltiplas referências de filtros

victor_franca — Wed, 05 Aug 2026 13:26:30 GMT

Há alguma alteração documentada ou uma atualização no mecanismo de otimização do Power BI, a partir de março/26, que possa ter tornado mais rigorosa a validação de filtros com múltiplas referências à mesma tabela dentro de uma função CALCULATE?
Tinha medidas antigas que estavam funcionando normalmente, apesar da semântica confusa, e passaram a retornar valores incorretos.
Tive que reescrevê-las de uma forma mais explicita e semântica para voltarem a funcionar.
Por exemplo:

Haskell

Medida Antiga = 
VAR QTDE =
CALCULATE(
    Count(Tabela1[Coluna1]), 
    Filter(Tabela2, [Coluna1] = 1),
    Tabela1,  // ← TABELA INTEIRA COMO FILTRO
    Tabela1[Coluna2]="Sim", 
    Filter(Tabela2, [Coluna2] = "1"),
    NOT(ISBLANK(Tabela1[Coluna3]))
)
   COALESCE(QTDE, 0)

Refeita para:

SQL

Medida Nova = 
VAR QTDE = 
CALCULATE(
        COUNT(Tabela1[Coluna1]),
        Tabela1[Coluna2] = "Sim",
        NOT(ISBLANK(Tabela1[Coluna3])),
        Tabela2[Coluna1] = "1",
        Tabela2[Coluna2] = "1"
    )
RETURN
    COALESCE(QTDE, 0)

Gostaria de entender o que mudou neste período para avaliar se precisarei revisar todas as medidas antigas em uso nos vários painéis que possuímos.

Obrigado!