Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Try your skills in the Power BI Dataviz World Championship! Round one ends June 26. Join now

Reply
RS_123
Frequent Visitor

how to refer to calculation item from DAX code

Hi,

I have built two calculation groups in my report. Please see picture below. I am trying to use [Total Revenue] in the DAX code 
Cal Group Img.PNG

in my DAX code the following way. The following code snippet is used in the definition of another calculation item, % of Total Rev - YTD.

 

VAR _YTDTotalRev = Calculate ([Toal Revenue], 'Time Intelligence' [Formula] = "YTD").

 

This gives an error: The value for [Total Revenue] cannot be determined. Either the column does not exist, or there is no current row for this column. 

 

In the definitive guide to dax, chapter 9, the book uses [Sales Amount] calculation item in DAX expression. I'm wondering why I am getting an error when I tried to use a calculation item while definining another calculation item. How can I use one calculation item in another without rewriting the code? Any help would be appreciated.

2 REPLIES 2
amitchandak
Super User
Super User

@RS_123 , is it typo here on the community . or you type wrong formula

 

VAR _YTDTotalRev = Calculate ([Toal Revenue], 'Time Intelligence' [Formula] = "YTD").

 

VAR _YTDTotalRev = Calculate ([Total Revenue], 'Time Intelligence' [Formula] = "YTD").

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Typo in the community. I have the correct measure name in my model.

Helpful resources

Announcements
Fabric Data Days is here Carousel

Fabric Data Days 2026

Don't miss out on Data Days, June 15 through August 7. Learn Fabric, Power BI, SQL, AI and more.

May Power BI Update Carousel

Power BI Monthly Update - May 2026

Check out the May 2026 Power BI update to learn about new features.

Power BI DataViz World Championships carousel

Power BI DataViz World Championships - June 2026

A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.