NateBI Contributor

My comment is disappearing post edit apologies Ok, @MichelleH that is very helpful. @RobSomers sure: Status Name = Current Status of ID Implementing = Total Hours spent in Status Implementing Filter on card: Status Name = Implementing My expectation here would be that the SUM() BM matches the Implementing Measure. Despite…

Thanks @MichelleH so the filter is applied first, then the BM is calculated. Sure @RobSomers an example with SUM(). Context: Dataset has distinct IDs, a Measure called 'Implementing' showing the number of hours each ID spent in the Implementing status and a Status Name categorical field showing the current status. (worth…

Hi @MamtaBolaki not in this scenario but I have noticed that Sorting properties affect figures. If we could add this to the list of how BMs handle external filters that would be great.

@MichelleH Ok this is helpful, so it applies the filter first (even within a card) then calculates the BM. @RobSomers , sure the one I have to hand is this SUM(Implementing) BM: The dataset has Distinct IDs . 'Implementing' is a Measure field showing the hours each ID has spent against the Implementing status. The 'Status…