Forum Discussion
conditional count
Hello all, I'm newbie to PowerBI and I need the comunity help. I have a table with 3 columns. The first column is "days" of July, the second column, the "hour" of a day when the temprature is r...
Anonymous
Try these MEASURES
File attached as well with your sample data
Max_Temp = Max(Table1[Temperature])
DataPoints_Till_MaxTemp = VAR maxtemp = [Max_Temp] VAR MyHour = CALCULATE ( MIN ( Table1[Hour] ), Table1[Temperature] = maxtemp ) RETURN COUNTROWS ( FILTER ( Table1, Table1[Hour] <= MyHour ) )Total Data Points = Count(Table1[Temperature])
Anonymous
Try these MEASURES
File attached as well with your sample data
Max_Temp = Max(Table1[Temperature])
DataPoints_Till_MaxTemp =
VAR maxtemp = [Max_Temp]
VAR MyHour =
CALCULATE ( MIN ( Table1[Hour] ), Table1[Temperature] = maxtemp )
RETURN
COUNTROWS ( FILTER ( Table1, Table1[Hour] <= MyHour ) )
Total Data Points = Count(Table1[Temperature])
Zubair,
Thanks a lot for your solution. I will let you know if that works on my dataset or not.
Best
Qmars