Forum Discussion

Davegent's avatar
Davegent
New Member
11 months ago
Solved

Help Please

Asset ID Customer Site Last Occurrence ( In Machine Time ) SMU (In Hrs) Target Payload Target Plus 10% Target Plus 20% Payload Weight   =COUNTIFS(Payload_Weight,">=0",Payload_Weigh...
  • Irwan's avatar
    Irwan
    11 months ago

    hello Davegent 

     

    i assumed the row 2 result come from the same formula as above.

     

    i am not sure how your visual will be but please check if this accomodate your need.

    create three measure for Green, Orange, and Red color calculation in row 2 with following DAX.

    Green =
    DIVIDE(
        COUNTX(
            FILTER(
                'Table',
                'Table'[Payload Weight]<'Table'[Target Payload]
            ),
            'Table'[Asset ID]
        ),
        COUNTA('Table'[Asset ID])
    )
    Orange =
    DIVIDE(
        COUNTX(
            FILTER(
                'Table',
                'Table'[Payload Weight]<'Table'[Target Plus 10%]
            ),
            'Table'[Asset ID]
        ),
        COUNTA('Table'[Asset ID])
    )
    Red =
    DIVIDE(
        COUNTX(
            FILTER(
                'Table',
                'Table'[Payload Weight]<'Table'[Target Plus 20%]
            ),
            'Table'[Asset ID]
        ),
        COUNTA('Table'[Asset ID])
    )

     

     
    Hope this will help.
    Thank you.
Irwan's avatar
Irwan
Super User
11 months ago

hello Davegent 

 

as far as my knowledge, countif can be expressed as countx in pbi and counta is same as excel.

so maybe something like this.

divide(

countx('payload',payload_weight>=0&&payload_weight<=222,9),

counta('payload'[column])

)

 

for dynamic value, you need to use measure and plot into visual. the visual will be change depend on the slicer value.

 

otherwise, please share your sample data that represent your original data (remove any confidential information)

 

Hope this will help.

Thank you.