DateDiff Measure + date Filters

[Anonymous]

Hello all,

I've built a measure that works but when I filter date it, it takes the entire year regardless. How do I make it work with filters?

My dax:

OEU = Divide( 

Sum(Consolidado[Resultado - REATOR]);       // this is working just fine.

Calculate(

DATEDIFF ( [First day of the year];         // The problem is here. I've created a datediff that gets last day of the table and 

[Last day on the table];                         // then subtracts the first day. So I have exactly my entire table period. 

minute) ;                                               // The problem is that this difference is not affected when I filter the table with

All(Consolidado) ) ;                                     // date slicers.

0)

Can anyone help me get this to work?

Thanks a lot in advance for those who take the time to try and solve this 🙂

[parry2k]

@Anonymous it will be easier to provide a solution if you share sample data with expected output. Read this post to get your answer quickly.

https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490