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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
AtchayaP
Helper V
Helper V

Dax

This is calculated column .

I want to use this calculation in measure .

But table name is not showing.

Can I know what changes to make in measure for this calculation. Please help me

16493643079422474119504977474898.jpg

@parry2k  @johnt75 @amitchandak 

6 REPLIES 6
VahidDM
Super User
Super User

Hi @AtchayaP 

 

Put your conditions in IF statment to the MAX  and then test it as a measure.

 

IF(MAX('TABLENAME'[Product Family])="XXX",....

 

If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
LinkedIn: 
www.linkedin.com/in/vahid-dm/

 

 

16494239516567331116481742561303.jpg

But it is showing error as MIN function accepts a column reference as an argument...could you help me with this code

bcdobbs
Super User
Super User

What error is it giving?



Ben Dobbs

LinkedIn | Twitter | Blog

Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!!

Table name is not showing , I have used same calculation in calculated column , I didn't get any error but while using in measure , table name is not showing

bcdobbs
Super User
Super User

Just to rule out an easy solution try putting inverted commas round the table name, eg

 

'TableName'[Column Name]

also no space between the table and column section.



Ben Dobbs

LinkedIn | Twitter | Blog

Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!!

1649367426074784476438814927337.jpg

 but still showing error

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

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

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.