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

Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.

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
FabCon Global Hackathon Carousel

FabCon Global Hackathon

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

Check out the October 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.