Forum Discussion

mumair's avatar
mumair
Icon for Helper I rankHelper I
9 years ago

Help with not double counting

My data looks like the following:   Shipment | Voyage | Product | Failed Tanks | Count of Failed Tanks 1000 | NA100 | A | 3D, 3E | 2 1001 | NA100 | A | 3D, 3E | 2 1002 | NA100 | A | 3D, 3E | 2 ...
Need Help
Eric_Zhang's avatar
Eric_Zhang
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

mumair

You'll need to re-model the dataset.

 

 

Then create a measure like

Count of Failed Tanks by Voyage = 
VAR cnt =
    CALCULATE (
        DISTINCTCOUNT ( yourTable[Failed Tanks] ),
        FILTER ( yourTable, yourTable[Failed Tanks] <> "N/A" )
    )
RETURN
    IF ( ISBLANK ( cnt ), 0, cnt )