topic Re: Column values in DAX Commands and Tips

Column values

Anonymous — Mon, 12 Oct 2020 06:58:03 GMT

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 DrivingIndex = VALUES(CombinedTable[drivingindex])

RETURN [Minutes]*(100-DrivingIndex)^3

Re: Column values

CNENFRNL — Mon, 12 Oct 2020 10:11:03 GMT

Hi, Anonymous , DAX measure is way different from Excel array formula; it's always used to aggregated data in a particular way (sum up, average, concatenate, etc.) in stead of return a series of results.

btw, in gereral, we can use ALL(CombinedTable) to retrieve an intact table, retaining all duplicates in each column.

Re: Column values

AlB — Mon, 12 Oct 2020 10:43:28 GMT

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

Re: Column values

Anonymous — Mon, 12 Oct 2020 11:36:36 GMT

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)