Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello,
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
Client Name | USD | Type | Ageing | Scope | Comments |
Client 1 | 10794 | External | |||
Client 1 | 3083 | External | |||
Client 1 | 3083 | External | |||
Client 2 | 10243 | External | |||
Client 3 | 11950 | BoB | |||
Client 3 | 19838 | BoB | |||
Client 4 | 2724 | BoB | |||
Client 4 | 2862 | External | |||
Client 4 | 8040 | BoB | |||
Client 4 | 43647 | BoB | |||
Client 4 | 4186 | BoB | |||
Client 5 | 2724 | BoB | |||
Client 5 | 9039 | BoB | |||
Client 6 | 3004 | BoB | |||
Client 7 | 264 | BoB | |||
Client 7 | 5498 | BoB | |||
Client 7 | 1787 | BoB | |||
Client 7 | 9622 | BoB | |||
Client 7 | 5773 | BoB |
I already have the counts of BOB and External but I want to link the counts with $.
Solved! Go to Solution.
@romovaro , example like
SUMX(Filter('Tablet', SEARCH("BoB", 'Table'[Type], , 0)>0), [USD])
or
SUMX(Filter('Tablet', 'Table'[Type] = "BoB" ), [USD])
Count External-Type = SUMX(Filter('Table', SEARCH("External", 'Table'[Type], , 0)>0), [USD] )
@romovaro , example like
SUMX(Filter('Tablet', SEARCH("BoB", 'Table'[Type], , 0)>0), [USD])
or
SUMX(Filter('Tablet', 'Table'[Type] = "BoB" ), [USD])
Count External-Type = SUMX(Filter('Table', SEARCH("External", 'Table'[Type], , 0)>0), [USD] )
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
99 | |
80 | |
70 | |
59 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |