Forum Discussion

Udit's avatar
Udit
New Member
2 years ago

Convert Calculated Column to measure

Consider the Following Power BI dashboard Model : We have 3 tables Table 1 : EM table There are no duplicate rows in the table. Table 2 : Norm Table MaxUpdateFlag1 - is calculated columns I...
lbendlin's avatar
lbendlin
Super User
2 years ago

 

I am looking to change MaxUpdateFlag1 to a measure.

 

Why? Can it be impacted by user interaction with the report?

 

your existing calculated column can be refactored to 

MUF = if([DMA_Date]=maxx(Norm,[DMA_Date]),1,0)

if you want to use a measure, rewrite this to 

MUF = if(SELECTEDVALUE(Norm[DMA_Date])=maxx(Norm,[DMA_Date]),1,0)