Forum Discussion
Helper IFYTD Measure Cannot be Sliced
Hi all!
I have a table like this:
There are many unique values in Scorecard column. Then, I created an FYTD measure for, let's say "FC DBNR" variable (under Scorecard column). The formula is like this:
| DBNR FC FYTD = TOTALYTD(AVERAGE('Consolidated'[Value]), Consolidated[Date].[Date],'Consolidated'[Scorecard]="FC DBNR","6/30") |
Financial year is ended out at 30th of June hence the last term "6/30".
Then I use this measure and date in a visual of line chart and table. Once I played with slicer, both table and line chart visuals only follow the starting month (in this case, September), but the end month always at June no where it should be December in this case.
Can you help me on this?
Thank you!
Akbar
Hi akbjf
Change to the following instead.
DBNR FC FYTD = TOTALYTD(AVERAGE('Consolidated'[Value]), Consolidated[Date],'Consolidated'[Scorecard]="FC DBNR","6/30")Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 Replies
- Greg_Deckler
Community Champion
Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2. 
v-juanli-msftCommunity Support
Hi akbjf
Change to the following instead.
DBNR FC FYTD = TOTALYTD(AVERAGE('Consolidated'[Value]), Consolidated[Date],'Consolidated'[Scorecard]="FC DBNR","6/30")Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
