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.
I am using CONCATENATEX to combine rows (the "Name" column in the example given bellow). Wondering how to remove the values appearing in the totals row.
Solved! Go to Solution.
Hi there,
You could do add some sort of check to your measure to ensure you return a result only for individual Identifiers.
The first measure works by detecting when a single Identifier value is visible.
The second measure works in a table visual where you have Identifier on the rows, and returns a nonblank value only at the "level" of a single Identifier.
Name without total = IF ( HASONEVALUE ( YourTable[Identifier] ), CONCATENATEX(...) ) Name without total = IF ( ISINSCOPE ( YourTable[Identifier] ), CONCATENATEX(...) )
Regards,
Owen
Hi there,
You could do add some sort of check to your measure to ensure you return a result only for individual Identifiers.
The first measure works by detecting when a single Identifier value is visible.
The second measure works in a table visual where you have Identifier on the rows, and returns a nonblank value only at the "level" of a single Identifier.
Name without total = IF ( HASONEVALUE ( YourTable[Identifier] ), CONCATENATEX(...) ) Name without total = IF ( ISINSCOPE ( YourTable[Identifier] ), CONCATENATEX(...) )
Regards,
Owen
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 |
---|---|
112 | |
100 | |
77 | |
74 | |
49 |
User | Count |
---|---|
146 | |
108 | |
106 | |
90 | |
62 |