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

MahyarTF's avatar
MahyarTF
Memorable Member
4 years ago

Hi,

Not sure if it is the best solution :

- In Power Query, I create two duplicated tables from my specific Table (T1 and T2)

- In T1, I filter the 'Equipment OEM' = 732

- In T2, I filter the 'Equipment OEM' <> 732

- In T1, Group Rows based on the 'Equipment OEM'

- In T1, changed the type 'Equipment' type to Text

- Append the T1 and T2 and Apply them to Power BI

- In Power BI, create the Table visual and bring the 'Equipment OEM' and 'Equipment' column

azakir's avatar
azakir
Resolver I
4 years ago

Hi MahyarTF . thanks for the suggestion. The issue is I've got a few more OEM model numbers that needs to be counted apart from 793. So thought I'll just include them in a formula for easy filtering