Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi All,
working currently on a project where I need to filter certain values from a database in order to categorize them.
I need to have a measure that says filter all part numbers starting with the letter A.
Thats my current function:
Filter function =
SUMX(
FILTER(
'AO Domestic',
'AO Domestic'[Part Number] = "STARTS WITH A"
)
,
'AO Domestic'[Total Actual Cost incl. Retro. Pay])
Would be great if someone could tell me how to correct the measure. Thanks a lot in advance.
Kind regards
Solved! Go to Solution.
Hey,
you can write your measure like so
Measure 3 = CALCULATE( SUM('FactWithDates'[Amount]) ,FILTER( 'FactWithDates' ,LEFT('FactWithDates'[Item],1) ="A" ) )
Hopefully this gets you started
Regards
Tom
Hey,
you can write your measure like so
Measure 3 = CALCULATE( SUM('FactWithDates'[Amount]) ,FILTER( 'FactWithDates' ,LEFT('FactWithDates'[Item],1) ="A" ) )
Hopefully this gets you started
Regards
Tom
Hi thank you very much - that works.
User | Count |
---|---|
141 | |
113 | |
104 | |
77 | |
64 |
User | Count |
---|---|
135 | |
123 | |
101 | |
71 | |
61 |