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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
prodigypenguin
Regular Visitor

Error: 'CALCULATE' is not a function

I'm building some analysis around Benford's law and am using the following code. This same code works just fine in another report. For some reason, I'm getting an error: "'CALCULATE' is not a function." and I can't find anything online that references this error. Any ideas?

 

Benford = var dig = 'Data'[TwoDigits] return IF(dig <> BLANK( ), CALCULATE(LOG10(1+1/dig)), BLANK( ))

 

 

1 ACCEPTED SOLUTION
prodigypenguin
Regular Visitor

That didn't help but introduced another error and now I think I know the issue: my data is direct query and some advanced measures (including the LOG10 function) aren't available in DQ.

View solution in original post

2 REPLIES 2
prodigypenguin
Regular Visitor

That didn't help but introduced another error and now I think I know the issue: my data is direct query and some advanced measures (including the LOG10 function) aren't available in DQ.

amitchandak
Super User
Super User

@prodigypenguin , Strange.

Try like

Benford = var dig = 'Data'[TwoDigits] return IF(dig <> BLANK( ), LOG10(1+1/dig), BLANK())

 

Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

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

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.