Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hello
I have a measure that computes the Day on Day variation of some datas, this is a measure called DataBase[DoD DN]
I have another measure that computes the cumulative Day on day variation DataBase[DoD DN **bleep**]
Everything works properly. I can plote in a line and stacked column charts and that's perfect.
Start Date 10jul
My probleme appires when I filter by dates, and move the start dates of what should be the start of the cumulative function?
It seems that the date filter does not apply to the measure so my cumumatlive does not starts at 0
start dates 12aug
Here his me DoD DN **bleep** measure
DoD DN **bleep** = CALCULATE(SUMX('DataBase';'DataBase'[DoD DN]); FILTER( all('DataBase'[ValuationDate]); 'DataBase'[ValuationDate]<=MAX('DataBase'[ValuationDate]) ) )
Any Advice ?
Many thanks in advance for you help !
Pierre
Solved! Go to Solution.
@pitucc,
You use ALL function in your cummulative measure, which ignores all date slicers and date selections in Visual/Page/Report filters.
Thus, when you apply date filter, the cummulative measure will show value of the first date(12aug) in your Axis, which is same as that value of the date(12aug) in the first screenshot. As long as the value is not 0, it will not be 0 in the second screenshot.
Regards,
Lydia
indeed... I've changed the ALL by a ALLSELECTED and now it works
Thanks !
@pitucc,
You use ALL function in your cummulative measure, which ignores all date slicers and date selections in Visual/Page/Report filters.
Thus, when you apply date filter, the cummulative measure will show value of the first date(12aug) in your Axis, which is same as that value of the date(12aug) in the first screenshot. As long as the value is not 0, it will not be 0 in the second screenshot.
Regards,
Lydia
indeed... I've changed the ALL by a ALLSELECTED and now it works
Thanks !
and here is the code of my DoD DN measure in case that's comming from here
DoD DN = VAR current_Product =LASTNONBLANK ( DataBase[Name]; [Name] ) VAR current_date = MAX ( DataBase[ValuationDate] ) VAR current_avg_parity = AVERAGEX ( FILTER ( ALL ( DataBase ); [Name] = current_Product && [ValuationDate] = current_date ); [Parity] ) VAR current_avg_cbprice = AVERAGEX ( FILTER ( ALL ( DataBase ); [Name] = current_Product && [ValuationDate] = current_date ); [Close] ) VAR previous_avg_parity = AVERAGEX ( FILTER ( ALL ( DataBase ); [Name] = current_Product && [ValuationDate] = MAXX ( FILTER ( ALL ( DataBase ); [Name] = current_Product && [ValuationDate] <(current_date) ); [ValuationDate] ) ); [Parity] ) VAR previous_avg_delta = AVERAGEX ( FILTER ( ALL ( DataBase ); [Name] = current_Product && [ValuationDate] = MAXX ( FILTER ( ALL ( DataBase ); [Name] = current_Product && [ValuationDate] < (current_date) ); [ValuationDate] ) ); [Delta] ) VAR previous_avg_cbpice = AVERAGEX ( FILTER ( ALL ( DataBase ); [Name] = current_Product && [ValuationDate] = MAXX ( FILTER ( ALL ( DataBase ); [Name] = current_Product && [ValuationDate] < (current_date) ); [ValuationDate] ) ); [Close] ) RETURN IF ( and(previous_avg_parity <> 0;previous_avg_cbpice<>0); (current_avg_cbprice-previous_avg_cbpice)-previous_avg_delta*( current_avg_parity - previous_avg_parity); 0 )
User | Count |
---|---|
128 | |
108 | |
99 | |
65 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |