Same visual works on one page and doesn't on another

[Anonymous]

Hello everyone!
So I have created a visual and as the title says it works on one page but not on another. Below I have shared some screenshots. I have no idea why that's happening.

[Anonymous · Accepted solution]

Hello everyone!
So I removed Percentile Difference Between Checkpoints measure and everything works now! So I am guessing something was wrong with that measure. 

Either way thank you all for trying to help!

Cheers!

[v-alq-msft]

Hi, @Anonymous 

Measures and calculated columns both use DAX expressions; the difference is the context of evaluation. A measure is evaluated in the context of the cell of the pivot table or DAX query, whereas a calculated column is computed at the row level of the table to which it belongs. The context of the cell depends on the user selections in the pivot table or on the shape of the DAX query.

While 'After Dialog Steps'/'Before Dialog Steps' measure returns a table where it is expected to return a scalar value. Please make sure the measure returns a single value.

Best Regards

Allan

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Anonymous , can you share the formula

[Anonymous]

Hi @amitchandak
Thank you for your reply. Here are the formulas

Before Dialog Steps = 
    var __BeforeDialogSteps = 
        SELECTCOLUMNS(
            FILTER(
                ST03N;
                [Date Time] = [Before Date]
            );
            "__BeforeDIA"; [Number of Dialog Steps]
        )
return
    __BeforeDialogSteps

(same as After Dialog Steps)

Percentage Difference Between Checkpoints = 
    var __Difference = [After Dialog Steps] - [Before Dialog Steps]
return
    DIVIDE(__Difference; [Before Dialog Steps])

Percentile Difference Between Checkpoints = 
var __BeforeTable = SELECTCOLUMNS(
            FILTER(ST03N; [Date Time] = [Before Date]);
            "Transactions"; [Report or Transaction name]
        )
var __AfterTable = SELECTCOLUMNS(
            FILTER(ST03N; [Date Time] = [After Date]);
            "Transactions"; [Report or Transaction name]
        )
var __Intersection = INTERSECT(__BeforeTable; __AfterTable)
var __FilteredByIntersection = FILTER(
            ALL(ST03N);
            ST03N[Report or Transaction name] = __Intersection
        )
return 
    CALCULATE([Percentage Difference Between Checkpoints]; __FilteredByIntersection)

[MFelix]

Hi @Anonymous ,

This is related to context (I can assume some of the values are measures correct?).

When calculating values in measures the final result is based on the context filters, slicers, axis (on charts), columns /rows (matrix or tables) and even within the formula itself. Looking at the image you present of the error believe that the calculation you are making for the Before Dialog Steps measure as some value with an ALL, ALLSELECTED, VALUES or similar that is not picking up a single value and then returning the multiple values.

On the first image I can see all the context that is implicit in the table but try to turn on/off some filters to check.

Be aware that this context sometimes comes from other visualizations in the same page.

[Anonymous]

Hi @MFelix 
Thank you for your reply!
Yes all three columns are Measures. But since there are on different pages and I don't think I have linked those pages in any way how could the context be influenced? 

[MFelix]

Hi @Anonymous ,

The question is not about the relationship between both pages but about what you are using in one of the pages that is not used on the other as context.

This can be a lot of things as I refered previously (a slicer, a filter, a x-axis) and so on.

Is it possible for you to share a sample file?

[Anonymous]

Hi @MFelix 
Unfortunately it contains sensitive data so I can't share it. But each page contains just this visual, I have not put any slicers anywhere and no other filters that I am aware of. The one filter I have put is one that discards any blank values, but even with that removed nothing changes. 
In other words, unless I've missed something, these are both the same pages with the same visuals and one shows something the other one doesn't.

[Anonymous]

@MFelix 
So I deleted the "working" table and tried to recreate it and I get the same issue. So I think there is something wrong with the measure. Which is weird because until today they worked 😛

[MFelix]

Hi @Anonymous ,

As I refered, and sorry for insisting on this, measure are based on context so all the changes you do to your visualizations have impact. On the first image you have you have a filter on the percentile diferrence Between checkpoints <> Blank does this new table has that filtering?

Do you have any other visualization on that specific page? 

I can see you have an intersection between two filtered values on your measure you also have reference to some other measures, without the full details is difficult to access were is the error or the missing context on your table.

Can you share a sample file please?

[Anonymous]

@MFelix 
I can't share a sample file so I do apologize for that. There are no other visuals on either page, nor other filters or slicers. Disabling the filter on the percentile diferrence Between checkpoints <> Blank didn't have any impact. I still got the error. Below I share all the measures I use.

I understand why you insist on context but I also insist that there should be no filter messing with those visuals. I have been staring at it all day and I can't find anything.

After Date = CALCULATE(MAX(ST03N[Date Time]); ALL(ST03N)) 

Before Date = CALCULATE(MIN(ST03N[Date Time]); ALL(ST03N))

After Dialog Steps = 
    var __AfterDialogSteps = 
        SELECTCOLUMNS(
            FILTER(
                ST03N;
                [Date Time] = [After Date]
            );
            "AfterDIA"; [Number of Dialog Steps]
        )
return
    __AfterDialogSteps

Before Dialog Steps = 
    var __BeforeDialogSteps = 
        SELECTCOLUMNS(
            FILTER(
                ST03N;
                [Date Time] = [Before Date]
            );
            "BeforeDIA"; [Number of Dialog Steps]
        )
return
    __BeforeDialogSteps

(I changed the name here)
PDBC Dialog Steps = 
    var __Difference = [After Dialog Steps] - [Before Dialog Steps]
return
    DIVIDE(__Difference; [Before Dialog Steps])

Percentile Difference Between Checkpoints = 
var __BeforeTable = SELECTCOLUMNS(
            FILTER(ST03N; [Date Time] = [Before Date]);
            "Transactions"; [Report or Transaction name]
        )
var __AfterTable = SELECTCOLUMNS(
            FILTER(ST03N; [Date Time] = [After Date]);
            "Transactions"; [Report or Transaction name]
        )
var __Intersection = INTERSECT(__BeforeTable; __AfterTable)
var __FilteredByIntersection = FILTER(
            ALL(ST03N);
            ST03N[Report or Transaction name] = __Intersection
        )
return 
    CALCULATE([PDBC Dialog Steps]; __FilteredByIntersection)