Forum Discussion
Filter table dynamically with slicers
- 6 years ago
Yes, this should be doable, what you need to do is create a Measure that checks if those two columns (date and customer) are filtered and if they are select the comment otherwise show blank.
Measure structure should resemble:
Comment_Measure = IF( ISFILTERED(INSERT DATE COLUMN), //Date filter check. IF( ISFILTERED(INSERT CUSTOMER COLUMN), //Customer filter check. MAX(INSERT COMMENT COLUMN), //Both were filtered. Blank() //Date was filtered but Customer wasn't, you can change this to a default //message like "Select Date & Customer for Comment" ), Blank() //Date wasn't filtered, you can change this to a default //message like "Select Date & Customer for Comment" )Now drop that Measure into the card. Keep in mind that this is assuming you only have one comment for a customer in a month, you would need to add more logic to grab a list for example if you have more.
Yes, this should be doable, what you need to do is create a Measure that checks if those two columns (date and customer) are filtered and if they are select the comment otherwise show blank.
Measure structure should resemble:
Comment_Measure =
IF( ISFILTERED(INSERT DATE COLUMN), //Date filter check.
IF( ISFILTERED(INSERT CUSTOMER COLUMN), //Customer filter check.
MAX(INSERT COMMENT COLUMN), //Both were filtered.
Blank() //Date was filtered but Customer wasn't, you can change this to a default
//message like "Select Date & Customer for Comment"
),
Blank() //Date wasn't filtered, you can change this to a default
//message like "Select Date & Customer for Comment"
)Now drop that Measure into the card. Keep in mind that this is assuming you only have one comment for a customer in a month, you would need to add more logic to grab a list for example if you have more.
- brinky6 years agoHelper IV
RMB Wow works like a charm, thanks a millon.
I'm asking as you got me into it, what if I have 2 or more comments for a customer in a month :smileyhappy:
I'm asking as if it's not that complicated I will do just in case such event will happen.
Thanks once agian.
Stephen
- Anonymous6 years agoNot applicable
You can you use the following code instead of the max() :
CONCATENATEX(VALUES(Fact_Table[Column]);Fact_Table[Columnt]; " - ")