Forum Discussion
Number of Rows based on multiple columns values
Hi Im relatively new in PowerBi and Im looking for some advice on how to solve a problem with my data I have a table where represent the cycle time to each machine. I need to know the machine who h...
fzn4hs I think I messed up and put the wrong column in for the summarize:
Measure =
// Assumes you have [Product] column in your visual
VAR __Table = SUMMARIZE('Table',[Mach],"__TotalCT",SUM('Table'[CT])
VAR __Max = MAXX(__Table,[__TotalCT])
RETURN
MAXX(FILTER(__Table,[__TotalCT]=__Max),[Process])Should be a summarize by Mach, not Process.
It does not recognize
[__TotalCT]Is this another column that I need to calculate? Or should be calculated in the same measure?