Skip to main content
Announcements
Accelerate Your Success: Fuel your data and AI journey with the right services, delivered by our experts. Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
griffin2571
Contributor
Contributor

Invalid Dimension when I use Set Analysis to a dimension to Table

I used this script when I added the dimension =Only({<[Condition of Car]={'Faulty'}>} [Status]) and the expression editor keeps showing it is okay. However, once I click okay I get an invalid dimension. When I used the alternative solution =Aggr(Only({<[Condition of Car]={'Faulty'}>} Status), Status) then I get duplicates in my data that I don't want. 

 

Is there a reason the first script will keep throwing back an invalid dimension? 

griffin2571_0-1670865472339.png

griffin2571_0-1670865598412.png

 

griffin2571_2-1670865496242.png

Status Corporate Dealer Location Condition of Car
Repair Shop Diamler Qatar Faulty
Repair Shop BMW Qatar Good
Repair Shop Diamler Qatar Faulty
Repair Shop Diamler Qatar Faulty
Repair Shop Diamler Qatar Faulty
Repair Shop Diamler Qatar Good
Repair Shop Diamler Qatar OBCD
Repair Shop Diamler Qatar OBCD
Repair Shop Diamler Qatar Faulty
Repair Shop Diamler Qatar Faulty
Repair Shop Diamler Qatar Faulty
Repair Shop Diamler Qatar Faulty
Repair Shop Diamler Qatar OBCD
Repair Shop Diamler Qatar Faulty
Repair Shop Diamler Qatar Faulty
Repair Shop Diamler Qatar Faulty
Repair Shop Diamler Qatar OBCD
Repair Shop Diamler Qatar OBCD
Repair Shop Diamler Qatar OBCD
Repair Shop Diamler Qatar Orange
Repair Shop Diamler Qatar Faulty
1 Reply
hic
Former Employee
Former Employee

The expression
=Only({<[Condition of Car]={'Faulty'}>} [Status])
is a valid measure, but not a valid dimension.

Unfortunaltely, the expression editor thinks the syntax is OK, when it in fact isn't.

The expression
=Aggr(Only({<[Condition of Car]={'Faulty'}>} Status), Status)
is a a valid dimension.

Where do you get duplicates?