Hi,
in pbi, i created a straight forward total measure
SUM( Table1 , Table1 Sales )
I than wrote another
SUMX( CALCULATETABLE( Table1, table1 sales < 10 ) , Table1 sales )
Which when dropped on a card gives the right answer , but if i use
CALCLATETABLE( Table1, Table1, Sales < 10 ) , [Total Sales Measure] )
, I get the wrong answer ?
but it's definitely iterating over a filtered table , just not as I would have thought.
I get 62 , correct, but when use the measure 76 , what's happening, I've attached the excel sheet but it is just a list of a few numbers.
RD
Bookmarks