Forum Discussion
Targeta with Values
I looked at your pbix. The reason that measure is not working in a card visual is that your measure includes reference to a RANKX measure that will not get a result in the context (for example, the visual does not have the client number).
I did look at one of the measures referenced in your parent measure and provide below a much more efficient way to write it. I didn't look at the overall approach, but this one measure should be written like this.
INC_VTA_MES1 New =
SWITCH (
AVERAGEX (
'MEDIDAS PEDIDOS',
[rank PED]
),
1, SELECTEDVALUE ( PEDIDO_1_MES_1[Value] ),
2, SELECTEDVALUE ( PEDIDO_2_MES_1[Value] ),
3, SELECTEDVALUE ( PEDIDO_3_MES_1[Value] ),
4, SELECTEDVALUE ( PEDIDO_4_MES_1[Value] ),
5, SELECTEDVALUE ( PEDIDO_5_MES_1[Value] ),
0
)
Regards,
Pat