Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Column values

Hello!   Is there a way to bring column values to a measure? I tried using "VALUES" function but it only gives unique values and i want all of the values inside that column. Measure = VAR D...
AlB's avatar
AlB
Community Champion
5 years ago

Hi Anonymous 

Can you explain a bit more what the operation you need exactly is? The DAX code you show does not make much sense since you are multiplying by a one-column table  What is [Minutes]?

Probably you'll need to use some kind of iterator based on the whole table, either CombinedTable or ALL(CombinedTable). In any case, we need more details to come up with an answer.

Please mark the question solved when done and consider giving kudos if posts are helpful.

Contact me privately for support with any larger-scale BI needs, tutoring, etc.

Cheers 

 

 

Anonymous's avatar
Anonymous
Not applicable
5 years ago

AlB 

 

So i have three different measures. Minutes, WeightedNumber and WeightedAverage. I have trouble with the WeightedNumber measure because i want to bring those drivingindexes that were counted in the Minutes measure. These measures are for a cubic average for my gauge visualization. Hopefully you can get some kind of a picture what i'm trying to do. Thank you for your help anyways.

 

Minutes =
VAR minimi = MIN(CombinedTable[Time]) VAR maksimi = MAX(CombinedTable[Time]) return IF(ISFILTERED(CombinedTable[Date]) || ISFILTERED(CombinedTable[driver_id]);
maksimi - minimi && COUNT(CombinedTable[drivingindex]) ; BLANK() )

WeightedNumber =
VAR DrivingIndex = ALL(CombinedTable[drivingindex])
RETURN [Minutes]*(100-DrivingIndex)^3

WeightedAverage = 100-([WeightedNumber]/[Minutes])^(1/3)

The error message that I keep getting next to my visualization