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.
Hi!
Please I need help. I have a table like this:
I need a measure that sum all the values (Column VALUE) except the row that duplicates ID and PRODUCT.
I want to put this measure the total in a card visualization.
Thank a lot!
Solved! Go to Solution.
Why don't you de-duplicate the table before you load it into PBI? In Power Query it's just as easy to do as clicking several buttons... And if you want to know how many dup rows there ware originally for a given row, you can store the count of the row in the table as well. This will retain all the information you have in the original table and the resultant table will be as small as possible, thus DAX will be faster on it.
[Measure] =
SUMX(
SUMMARIZE(
T,
T[ID],
T[Product],
T[Value]
),
T[Value]
)
Try this
Measure = CALCULATE(SUMX(Tabela,Tabela[VALUE]), FILTER(Tabela,Tabela[ID]))
You can use a card with this measure.
@daromel , Power Query, Remove duplicate rows: https://www.youtube.com/watch?v=Hc5bIXkpGVE
In Dax =
New table =distinct(Table)
or summarize(Table,Table [ID],Table[Product],Table[Value])
Why don't you de-duplicate the table before you load it into PBI? In Power Query it's just as easy to do as clicking several buttons... And if you want to know how many dup rows there ware originally for a given row, you can store the count of the row in the table as well. This will retain all the information you have in the original table and the resultant table will be as small as possible, thus DAX will be faster on it.
Thanks for the answering,
The table has others fields that I need.
No all the fields are duplicates, just some of then.
[Measure] =
SUMX(
SUMMARIZE(
T,
T[ID],
T[Product],
T[Value]
),
T[Value]
)
It worked perfect. thank you!!
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 |
---|---|
43 | |
20 | |
20 | |
16 | |
15 |
User | Count |
---|---|
46 | |
28 | |
25 | |
18 | |
17 |