I'm trying to do a report to have supplier name as header. The same report should serve with only one supplier selected from filter or several. Header is currently a card that shows first value of name column, but the problem is that if user selects multiple suppliers, then only the first is shown.
I would like that card to show blank (or maybe "Selected Suppliers") value if multiple values are selected. I already got made a measure to give Y or N depending if more than one is selected but that can't be used as visual filter as it is a measure (correct me if I'm wrong but that gave only frozen filter :)).
Card single value check = IF(CALCULATE(DISTINCTCOUNT(SUPPLIER_DATA_TABLE[SUPPLIER_NAME]);ALLSELECTED(SUPPLIER_DATA_TABLE[SUPPLIER_NAME))=1;"Y";"N")
One idea is to create blank row to SUPPLIER_DATA_TABLE and sort it by SUPPLIER_NAME, but does anyone have an idea how to get around this problem without changing the source? Thanks!
As I didn't find autofit text size option for cards I ended up using both of these in two non-background cards stacked. First one shows only if one supplier is selected with a bit modified @Asac_14 code in big font and second one uses both codes combined to show values if multiple vendors are selected with smaller font. Makes effect of scalability in a card. 🙂