Debugging measure

[Dunner2020]

Hi there,

I created a measure that calculates some values. The measure looks like as follow:

Normalized SAIDI 24 hrs Unplanned =

var Time30Min = MAX('Outages and Interruptions'[Epoch Half Hour Number])

Return

CALCULATE ( SUMX(

FILTER(

filter(ALL('Outages and Interruptions'),'Outages and Interruptions'[Epoch Half Hour Number] <= Time30Min && 'Outages and Interruptions'[Epoch Half Hour Number] >= Time30Min-47),

[Zero Min Interruption]&&[Zero Customer Interruption]&&[External and LV interruptions]&&[description not contains]&&[Unplanned Interruption]),  [Normalised SAIDI 30 Mins Unplanned]))

I noticed that some measure is not producing the desired result. So I decided to debug and wrote another measure which looks like as follow:

 Debug =

var Time30Min = MAX('Outages and Interruptions'[Epoch Half Hour Number])

Return

CALCULATE ( COUNTROWS(

FILTER(  filter(ALL('Outages and Interruptions'),'Outages and Interruptions'[Epoch Half Hour Number] <= Time30Min && 'Outages and Interruptions'[Epoch Half Hour Number] >= Time30Min-47),

[Zero Min Interruption]&&[Zero Customer Interruption]&&[External and LV interruptions]&&[description not contains]&&[Unplanned Interruption])))

I found that actual measure performs calculation on 3 rows instead of 2 rows. Now I want to see what are those 3 rows. Could anyone guide me on how can I modify my debug measure so that it shows the actual rows instead of the count of row? Moreover, what is a good way of debugging the measure?

[Greg_Deckler · Accepted solution]

@Dunner2020 - Here is a good trick:

Normalized SAIDI 24 hrs Unplanned =
var Time30Min = MAX('Outages and Interruptions'[Epoch Half Hour Number])
Return
CALCULATE ( CONCATENATEX(
FILTER(
filter(ALL('Outages and Interruptions'),'Outages and Interruptions'[Epoch Half Hour Number] <= Time30Min && 'Outages and Interruptions'[Epoch Half Hour Number] >= Time30Min-47),
[Zero Min Interruption]&&[Zero Customer Interruption]&&[External and LV interruptions]&&[description not contains]&&[Unplanned Interruption]),  [Normalised SAIDI 30 Mins Unplanned]),",")

Replace your aggregator like SUMX with CONCATENATEX and then you can see what is going on "inside" your table essentially. Also, consider breaking your CALCULATE up into additional variables and then you can return individual variables as part of the measure to essentially look at what is going on inside at every step of the measure.