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.
v-echaithra's avatar
v-echaithra
Community Support
11 months ago

Hi Davegent ,

Thank you Irwan  for your updates.

We’d like to follow up regarding the recent concern. Kindly confirm whether the issue has been resolved, or if further assistance is still required. We are available to support you and are committed to helping you reach a resolution.

Best Regards,
Chaithra E.