Forum Discussion

Frequent Visitor

3 years ago

Solved

Stop repeating numeric values

Hi All, I have two datasets on different levels of granularity. Because of this, the numeric values in the second dataset gets repeated. Is there a way in DAX where I can isolate only one value ...

Data Modeling

Ahmedx
3 years ago
you need see this
https://community.powerbi.com/t5/Desktop/DAX-Help-Find-Duplicate-Values-and-Mark-duplicated-values-as/m-p/3152176#M1064990
or
https://community.powerbi.com/t5/Desktop/Change-Duplicate-Rows-to-Zero-Null-NOT-Delete/m-p/3115116#M1055348

Ahmedx

Super User

3 years ago

you need see this
https://community.powerbi.com/t5/Desktop/DAX-Help-Find-Duplicate-Values-and-Mark-duplicated-values-as/m-p/3152176#M1064990
or
https://community.powerbi.com/t5/Desktop/Change-Duplicate-Rows-to-Zero-Null-NOT-Delete/m-p/3115116#M1055348

Forum Discussion

Stop repeating numeric values

Related content

Bottom 10 considering repeated value.

Paginated Report headers not repeating

Cumulative Sum without repeat value

Count repeating values

Same values repeated