Forum Discussion
Create Measure on A Summarized Column
Hi All,
I have a column that is already summarized by power BI. I want to use DAX to create a new Measure/Column(not sure most appropriate) where there is a condition that a particular column is not Blank. Using my data sample, I want to create new processing time where Table[Processing Complete] <> BLANK() or "-". Thanks in advance.
Thanks tamerj1 I was able to achieve my main goal by creating a new temporary with the required conditions.
4 Replies
Hi Anonymous
New Column =
IF ( 'Table'[Processing Complete] = BLANK() || 'Table'[Processing Complete] = "-", BLANK(), Table'[Procrssing Time] )Thanks tamerj1 I was able to achieve my main goal by creating a new temporary with the required conditions.
Anonymous This looks like a measure aggregation problem. See my blog article about that here: https://community.powerbi.com/t5/Community-Blog/Design-Pattern-Groups-and-Super-Groups/ba-p/138149
The pattern is:
MinScoreMeasure = MINX ( SUMMARIZE ( Table, Table[Group] , "Measure",[YourMeasure] ), [Measure])
MaxScoreMeasure = MAXX ( SUMMARIZE ( Table, Table[Group] , "Measure",[YourMeasure] ), [Measure])
AvgScoreMeasure = AVERAGEX ( SUMMARIZE ( Table, Table[Group] , "Measure",[YourMeasure] ), [Measure])
etc.Thanks Greg_Deckler I was able to achieve my main goal by creating a new temporary table with the required conditions.
