I need to be able to have several lists list that allow individual items to be checked. These items will have associated costs. After the needed ones are checked, a total field will be activated and the total cost will be provided. Guidance? Thanks!
@Hank_Austin
You can try with this:
SUM(
SELECT(
Tablename[PriceColumn],
IN(
[CostItemsColumnName],
[_THISROW].[EnumlistColumnName]
)
)
)
Thank you I will!
User | Count |
---|---|
43 | |
28 | |
23 | |
14 | |
14 |