Measure with selectedvalue works but when I want to sort the selected values it stops working...

[A_a_a]

Hi All,

I have one measure with Selectedvalue measure.

Everything is ok, but when I want to sort the column which i use in the Selectedvalue measure, it stop working and the output is incorrect.

Please see my measures:

1) Selected A = SELECTEDVALUE('Table1'[A])

2) ABCD =

var v=[Selected A]

var c1 = calculate(sum('Table1'[Time]),'Table1'[Activity] = "Run",'Table1'[A]=v)

var c2 = calculate(sum('Table1'[Time]),'Table1'[Activity] = "Run",All('Table1'[A]))

var cfin= divide(c1,c2,0)

var ctotal = divide(c2,calculate(sum('Table1'[Time]),All('Table1'[A]),All('Table1'[Activity])),0)

var output = IF(COUNTROWS(VALUES('Table1'[A]))=1,cfin,ctotal)

return output

Measures work properly, but when I want to sort A by another column just to change the order, in all cells the output is 100 % (except Total - in both scenarios Total figure is correct).

Please help.

Thanks,

G.

[amitchandak]

@A_a_a , Try like

ABCD =
var v=[Selected A]
var c1 = calculate(sum('Table1'[Time]),filter('Table1', 'Table1'[Activity] = "Run" && 'Table1'[A]=v))
var c2 = calculate(sum('Table1'[Time]),filter('Table1', 'Table1'[Activity] = "Run"),All('Table1'[A]))
var cfin= divide(c1,c2,0)
var ctotal = divide(c2,calculate(sum('Table1'[Time]),All('Table1'[A]),All('Table1'[Activity])),0)

var output = IF(COUNTROWS(VALUES('Table1'[A]))=1,cfin,ctotal)

[A_a_a]

Hi @amitchandak 

Thank you for that.

Unfortunately, now it shows 100 % everywhere, even before sort by column...

[A_a_a]

Hi @amitchandak 

I think the issue is with Selected A = SELECTEDVALUE('Table1'[A]) -

by default in matrix table i can see:

A

0

1

2

3

4

...

23

but I need to see it as:

6

7

8

9

...

5

I created an additional column so I can sort the numbers in order that I need, but then the output of ABCD measure is incorrect (100% everywhere).

Is there any solution that I can have measure SELECTEDVALUE sorted by another column... because 'sort by column' is providing wrong calcuations.

Thanks,

G.