Thanks for replying so promptly.
My Level1 column is not a measure. It is purely a column from the table. So I cannot use
SWITCH( TRUE(), ‘Financial Categories’[Financial Statement List] as it has to be a measure after TRUE(),?
Is there anyway I can use the column and item in the column instead of a measure.
I will try to mask my data in PBIX as you suggested. There is a similar question I found in Power BI forum. but the solution does not work for me.
Report Show Both YTD Budget and Full Yr Budget
12-28-2017 12:05 PM
I’m fairly new to Power BI and Dax but was wondering if anyone knew how to show the Budget both as of YTD and Full Year while the report is using slicers?
***My request is to show Actual vs Budget and Full Year Budget minus Actual to show Year to Go. ***
***I am am also using slicers for each month of the calendar year so that my end users may also do Month to Date. ***
***I have no problem with the Actual vs Budget YTD it’s just can I also have Full Yr Budget? My Budget is by product level. ***
Thanks in Advance
Message 1 of 2
Re: Report Show Both YTD Budget and Full Yr Budget
01-03-2018 11:40 PM
***To get the Full Year Budget based on the selection in slicer, you can write a measure like below: ***
Measure = CALCULATE(SUM(‘Internet Sales’[Sales Amount]),ALLSELECTED(‘Date’[Calendar Year]))