I am currently going through the Financial Reporting with Power BI course.
I have a question on the Income statement sections re the Overlay main DAX formula combination to template design and using the switch true formula to calculate “Selected Year Actuals” measure for the Total Revenues row.
I followed the example (refer to 2:50 of the video) and getting a blank number for the measure created. The Total Revenues value in the video is $205,994.82 and not able to see this when I created the measure. The measure is not returning anything. The row is just blank
See measure details below: ( screen copy included)
Selected Year Actuals =
VAR CurrentItem = SELECTEDVALUE(‘Income Statement Template’[Items (Normalized)] )
CurrentItem = “Total Revenues” , DIVIDE([Revenues] , 1000, 0 ) ,
looking forward to getting feedback