Hello All,
I'm newby of using dax and especilly Power Bi. I'm trying to sum values based on distinct values on antoher column.
I have two columns "Description problems" and "Value". In the description problems column I have repeately description. I would like to count only description problems which are unique. Or in anoher words sum only the values in "values columns" which belong to unque description. For example: I woud like to get total 5 at the end based on the table bellow:
| Description problems | Values | Repeat |
| A & C Phase line and load side stab to interconnecting bus connections for normal power on ATS switch. | 1 | 3 |
| A & C Phase line and load side stab to interconnecting bus connections for normal power on ATS switch. | 1 | |
| A & C Phase line and load side stab to interconnecting bus connections for normal power on ATS switch. | 1 | |
| A (black) phase load & line side wire lug connection on feeder terminal block. | 1 | 2 |
| A (black) phase load & line side wire lug connection on feeder terminal block. | 1 | |
| A (black) phase load side wire lug connection on circuit breaker main for F-2. | 1 | 2 |
| A (black) phase load side wire lug connection on circuit breaker main for F-2. | 1 | |
| A Load side wire lug connection on 3 pole breaker #7 | 1 | 1 |
| A phase #10 Line side screw connection between bus and breaker | 1 | |
| A phase blade stab contacts and/or pivot bolt connection on disconnect switch. | 1 | 4 |
| A phase blade stab contacts and/or pivot bolt connection on disconnect switch. | 1 | |
| A phase blade stab contacts and/or pivot bolt connection on disconnect switch. | 1 | |
| Total | 5 problems | |
Woudl you please help me and give me some ideas, what is the correct measure syntaxt to sum up the values based on unique problem description?
Br,
