Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello
So I have a card visualization that displays the "Account name" when selected in a matrix. But if you drill down the matrix also displays invoice number. FYI the matrix only has 2 rows; Account name and Invoice number.
Currently I have the card using this measure but it only works for the first row, Account name:
FlagsSelected = IF ( ISFILTERED ('Table'[AccountName]),
CONCATENATEX(ALLSELECTED(Table[AccountName]), Table[AccountName], ", ")
,
"No Account Selected"
)
It only works for Account name. If I drill down to invoice number and select a respective number it wont display in the card visualization.
How do I alter my measure to work for both in the matrix.
And If I add a 3rd 4th row potentially...
Thanks
Solved! Go to Solution.
Hi @AA622
Try this measure
FlagsSelected =
SWITCH (
TRUE (),
ISFILTERED( 'Table'[InvoiceNumber] ),
CONCATENATEX (
ALLSELECTED ( 'Table'[InvoiceNumber] ),
'Table'[InvoiceNumber],
", "
),
ISFILTERED ( 'Table'[AccountName] ),
CONCATENATEX (
ALLSELECTED ( 'Table'[AccountName] ),
'Table'[AccountName],
", "
),
"No Account Selected"
)
Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.
Hi @AA622
Try this measure
FlagsSelected =
SWITCH (
TRUE (),
ISFILTERED( 'Table'[InvoiceNumber] ),
CONCATENATEX (
ALLSELECTED ( 'Table'[InvoiceNumber] ),
'Table'[InvoiceNumber],
", "
),
ISFILTERED ( 'Table'[AccountName] ),
CONCATENATEX (
ALLSELECTED ( 'Table'[AccountName] ),
'Table'[AccountName],
", "
),
"No Account Selected"
)
Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.
Extend your measure to check for the scope - ISINSCOPE can tell you where in the hierarchy you are.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
94 | |
80 | |
66 | |
58 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |