Forum Discussion
Bizarre behaviour when adding a measure to a table
It's weird if you don't know what's happening but not weird if you do. Powerbi visuals are very sensitive to the measures that are in those visuals. The visuals show combinations of data in the rows for which a measure has a value. If the measure value is blank, the row is not displayed.<- (this is important)
When you create a measure, for example, measureA = 1, and put that in a visual, you will see all combinations of data which produce a non-blank value in the measure. In this case, the measure is always 1 so you get to see all combinations i.e. lots of rows.
Now that doesn't really get you any closer to solving your original problem but that's why multiple rows are appearing in the visual.
It's weird if you don't know what's happening but not weird if you do. Powerbi visuals are very sensitive to the measures that are in those visuals. The visuals show combinations of data in the rows for which a measure has a value. If the measure value is blank, the row is not displayed.<- (this is important)
When you create a measure, for example, measureA = 1, and put that in a visual, you will see all combinations of data which produce a non-blank value in the measure. In this case, the measure is always 1 so you get to see all combinations i.e. lots of rows.
Now that doesn't really get you any closer to solving your original problem but that's why multiple rows are appearing in the visual.
HotChilli YES! You are 100% right! With your help, I modified my formula as follows:
var hrs = [Total care mins]/60Returnif(ISBLANK(hrs), blank(),int(hrs) & ":" & format(round(mod(hrs, 1)*60, 0), "00"))FIXED! Legend! Thank you.
