How to show a result only once per index and product

[Spotto]

hello guys, I need some help, I made a table that contains a measure that calculates the difference between two columns and back 1 or 0, when it brings 1 it shows a red icon as below (x in red)

Sla Estourado =

var SlaAcum = _Medidas[Acumulado sla]

var SlaAtual = SUM('Relatório de Histórico de Casos'[SLA Actual])

return

if((SlaAtual - SlaAcum)>0,0,1)

-----------------------------------------
I would like to get the index, nr Caso, and show only the first time the measure returns 1 (x in red) in DAX

Arquivo SLA 

I thank the help of all you 🙂

[Anonymous · Accepted solution]

I exported you calculated table and applied to it your requirements.

see if it is what you are after

[Anonymous]

I believe that with the function table.group and table.first or table.min you could solve your problem.
if you want more specific help upload an input table so it can be copied easily.

[Spotto]

I put the attached file, thanks for the help 🙂

[Anonymous · Accepted solution]

I exported you calculated table and applied to it your requirements.

see if it is what you are after

[Spotto]

it worked thanks, but the columns, formulas, measurements I did in DAX, I would have to do all of them in power query M to be able to group as you did?
From your example I even thought of using summarize but it didn't work.

[Anonymous · Accepted solution]

Hi @Spotto ,

But that's okay, I'll give an example to demonstrate how to keep the first line and delete the others.

1.Create a conditional column named Custom.

2.Select both the Nr CASO column and the Custom column, then group by

3.Add another custom column, if custom column = 1, then return the first row in the Count column, otherwise return the Count column.

4.Expand the rows and remove the unneeded columns, get the result.

Hope it helps you.

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.