How in a column to not show some values based on a change in another column

[Slaper]

Hello,

I have a table named tbl. In report view I created a table like below with some measure.
Now my question is how do I get the calculated value only on the last row just before an other Team, and not on each row as I wrote What i get. The %_value calculate I with two measures.

I use this table as a tooltip

%_value	Team	Order	Time Run	Time Run net		what i get
	T_1	o_1	1:10	1:00		111%
111%	T_1	o_2	2:10	2:00		111%
	T_2	o_2	0:55	1:00		81%
81%	T_2	o_3	3:00	3:50		81%
	T_3	o_4	2:00	1:50		98%
	T_3	o_5	0:10	0:20		98%
	T_3	o_6	0:20	0:22		98%
98%	T_3	o_7	0:53	0:55		98%
	%_Val = SUM(tbl[Time Run]) / SUM(tbl[Time Run net])
	%_Value = CALCULATE([%_Val],ALLEXCEPT(tbl,tbl[Team]))

[Slaper · Accepted solution]

The filter was a slicer , but with dates its was not working, so I punt a filter on 'Filter on this visuale' and if a other value was Blank, then this record was not shown 🙂

I used it for a tooltip.

[v-yifanw-msft]

Hi @Slaper ,

Please follow these steps:

1.        Turning Measure into Column

Column%_Val =
'Table'[Time Run] / 'Table'[Time Run net]

Column%_value =
CALCULATE ( [%_Val], ALLEXCEPT ( 'Table', 'Table'[Team] ) )

2.         Arrange in order with measure

sequence =
RANKX (
    FILTER (
        ALL ( 'Table' ),
        'Table'[Column%_value] = SELECTEDVALUE ( 'Table'[Column%_value] )
    ),
    CALCULATE ( MAX ( 'Table'[Order] ) ),
    ,
    DESC,
    DENSE
)

3.        Final output

result =
IF ( 'Table'[sequence] = 1, 'Table'[%_Value], "" )

How to Get Your Question Answered Quickly - Microsoft Fabric Community

If it does not help, please provide more details with your desired out put and pbix file without privacy information.

^{Best Regards,}

^{Yifan Wang}

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

[Slaper]

thanks for the reply, but I use this for a tooltip , and want to filter over year month week day, for the moment it  gives all the date and does not want to filter