data division

[Anonymous]

hiiii 

i tried using this formula to get hit and miss of sla its been executed but the data is divided into two equal halfes.

CALCULATE (

    COUNT ( Query1[Priority] ),

    FILTER (

        Query1,

        Query1[SLA Status] = "FULFILLED"

&& Query1[Exempted SLA] = "N"

            && Query1[Priority] = "PLI_NBD"

    )

)

[ilton]

Hi @Anonymous, could you explain what you'r trying to do? 

[BA_Pete]

Hi @Anonymous ,

Any chance you can provide some sample data please?

Make sure to remove any sensitive information.

Pete