Day before as I selected in slider

[Anonymous]

Hi all,

I have a dashboard like this:

As you can see is shown the total orders and the total of the incidents per day. Showing by default the most recent day with data and day -1. 

The question is, when I'm using the sliders on the top,i have this result:

As you can see, the day -1 is showing blank.

The measure that I'm using for all the cards are:

Orders

Ordenesultimodia-1 = 
VAR _antedate = 
    MAX ( 'Dataset'[Transformed DATA] )-1
RETURN
    CALCULATE (
        count ( 'Dataset'[NumOE] );FILTER('Dataset';
        'Dataset_LuisSimões'[Transformed DATA] = _antedate
    ))

Incidents

Incidenciasultimodia-1 = 
VAR _antedate = 
    MAX ( 'Dataset'[Transformed DATA] )-1
RETURN
    CALCULATE (
        COUNT ( 'Dataset'[TIPO] );FILTER('Dataset;
        'Dataset'[Transformed DATA] = _antedate && LEFT( 'Dataset'[TIPO];2) = "AN"
))

Quality service

CS%dia-1 = 1-([Incidenciasultimodia-1]/[Ordenesultimodia-1])

I hope you can help me , I'm blocked.

[v-danhe-msft · Accepted solution]

Hi @Anonymous,

Based on my test, your formula could work on my side:

Sample data:

Result:

In your picture, could you please check if there is a row or data in 2018/12/3?

Regards,

Daniel He

[Anonymous]

Hi @v-danhe-msft

Thanks for your help 🙂

I replicated your formula in my measure and works fine :-). My error was adding the command ALL in the date instead of in the count.

[themistoklis]

@Anonymous

Can you change the following formula:

MAX ( 'Dataset'[Transformed DATA] )-1

To this formula and see if it works?

CALCULATE ( MAX ( 'Dataset'[Transformed DATA] )-1, ALLSELECTED ( 'Dataset' ) )

[Anonymous]

@themistoklis

still showing blank like the previouse photo

Ordenesultimodia-1 = 
VAR _antedate = 
    CALCULATE( MAX ( 'Dataset'[Transformed DATA] )-1;ALLSELECTED('Dataset))
RETURN
    CALCULATE (
        count ( 'Dataset_[Nº OE] );FILTER('Dataset;
        'Dataset[Transformed DATA] = _antedate
    ))

[themistoklis]

@Anonymous

Can you share the file with us? Mask any sensitive data

[Anonymous]

@themistoklis

Imposible , Is not possible to share 😞

[Anonymous]

Any idea? I was checking and should be something related to the filter but I don't know how to avoid the filter for that measure.