cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
cromero Regular Visitor
Regular Visitor

Day before as I selected in slider

Hi all,

 

I have a dashboard like this:

 

1



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:

 

 

2

 

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.

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: Day before as I selected in slider

Hi @cromero,

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

Sample data:

1.PNG

Result:

1.PNG

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

 

Regards,

Daniel He

Community Support Team _ Daniel He
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
7 REPLIES 7
themistoklis New Contributor
New Contributor

Re: Day before as I selected in slider

@cromero

 

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' ) )

 

cromero Regular Visitor
Regular Visitor

Re: Day before as I selected in slider

@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 New Contributor
New Contributor

Re: Day before as I selected in slider

@cromero

 

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

cromero Regular Visitor
Regular Visitor

Re: Day before as I selected in slider

@themistoklis

 

Imposible , Is not possible to share :-(

cromero Regular Visitor
Regular Visitor

Re: Day before as I selected in slider

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.

Community Support Team
Community Support Team

Re: Day before as I selected in slider

Hi @cromero,

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

Sample data:

1.PNG

Result:

1.PNG

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

 

Regards,

Daniel He

Community Support Team _ Daniel He
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
cromero Regular Visitor
Regular Visitor

Re: Day before as I selected in slider

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.