Forum Discussion

azakir's avatar
azakir
Resolver I
4 years ago
Solved

IF Condition To Display All Values From A Column

Hi Guys. Need some help on an IF formula that I am trying to work out. Here's sample data:     What I am after is a measure which counts the number of Equipment code if OEM model is "793", ...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Guys

    My approach using a calculated table. However getting error for "variant data type". Any suggestions?

    Table =
ADDCOLUMNS (
    SUMMARIZECOLUMNS (
        'Equipment OEM'[Equipment OEM],
        "Count of Equipment", COUNTROWS ( 'Equipment OEM' )
    ),
    "Measure",
        IF (
            [Count of Equipment] >= 2,
            [Count of Equipment],
            FORMAT ( 'Equipment OEM'[Equipment OEM], "#.##" )
        )
)



     Thanks

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Guys

My approach using a calculated table. However getting error for "variant data type". Any suggestions?

Table =
ADDCOLUMNS (
    SUMMARIZECOLUMNS (
        'Equipment OEM'[Equipment OEM],
        "Count of Equipment", COUNTROWS ( 'Equipment OEM' )
    ),
    "Measure",
        IF (
            [Count of Equipment] >= 2,
            [Count of Equipment],
            FORMAT ( 'Equipment OEM'[Equipment OEM], "#.##" )
        )
)



 Thanks