Quick question. I have a table with different columns. I have one that shows USD value and another one Type (can be External or BoB)
I want to create 2 measure in the table below that shows per row the:
- Amount $ USD External
- Amount $ USD Bob
I already have the counts of BOB and External but I want to link the counts with $.
Go to Solution.
@romovaro , example like
SUMX(Filter('Tablet', SEARCH("BoB", 'Table'[Type], , 0)>0), [USD])
SUMX(Filter('Tablet', 'Table'[Type] = "BoB" ), [USD])
Count External-Type = SUMX(Filter('Table', SEARCH("External", 'Table'[Type], , 0)>0), [USD] )
View solution in original post
Take a look at the September 2023 Power BI update to learn more.
Join Microsoft Reactor and learn from developers.