Creating 4 new measure based on "startswith" ?

[RasmusLVF]

Hi

I am trying to create 4 new measures based on a single value column - the problem is that my value column contains a bunch of units (energy consumption, volume, temperatures)

The differentiation is based on another column which defines the value type. I need to create calculations based on the values so I need to split them in difference columns.

I assume the calculation looks something like this:

"IF "startswith" 5.T1 THEN value = Measure1

"IF "startswith" 5.T2 THEN value = Measure2

"IF "startswith" 5.T4 THEN value = Measure3

"IF "startswith" 5.T5 THEN value = Measure4

Im pretty new in Powerbi coming from Tableau, any help is greatly appreciated.

Thanks 🤘

[Anonymous · Accepted solution]

@RasmusLVF 

This is not the way to do it. Use Power Query to shape the data correctly and then your DAX measures will be as easy as 1-2-3. If you don't know what the term "tidy data" means, then I'd suggest looking at What’s Tidy Data?. How to organize messy datasets in… | by Rodrigo Marino | Towards Data Science and/or Tidy data (r-project.org).

[amitchandak]

@RasmusLVF , Create measures like

Measure1 = calculate(sum(Table[Value]), filter(Table, left(Table[Column],3) = "5.T1"))

[RasmusLVF]

Thanks alot, that didnt appear to return any values though.

Measure1 = calculate(sum('Readings'[value]), filter(Readings', left('Readings'[Series],3) = "5.T1"))