Get% compliance from a column in Power BI

Navigation
0

I'm doing a column calculated in Power BI called Compliance, the column is formed as follows: 

    Cumplimiento = IF('SLA Service Now'[Ha producido una infracción]=FALSE(),(
DIVIDE(COUNT('SLA Service Now'[Status SLA]),[Conteo de tickets],90)))

If I show only the following data, the table is displayed correctly.

But if I add the Compliance field, the calculation is not performed and the table is displayed badly.

Any ideas or suggestions that you could give me would come in handy.

Greetings.

    
asked by Guillermo Ricardo Spindola Bri 20.07.2018 в 17:44
source

1 answer

0

I'm just starting out in this world and I imagine that you have already found the solution, but I think you could use the CALCULATE function. 'CALCULATE (Expression; [Filter 1]; [Filter2]; ...)'

The formula would look like this:

Cumplimiento = CALCULATE(DIVIDE(COUNT('SLA Service Now'[Status SLA]),[Conteo de tickets],90),'SLA Service Now'[Ha producido una infracción]=FALSE())

This page gives quite complete information about the function CALCULATe in case it interests: CALCULATE on DAX: The Queen of Functions

    
answered by 15.01.2019 в 12:05
Java multithreading using JDBC I do not see the option value menu in PHP