I am using the Chiclet slicer with two possible options (A, B) but using the Multiple Selection setting = ON and the Forced Selection setting = OFF.
I want to show the items that match on another table on the page.
This gives me four possibilities with the following required outputs
A on, B on - show all values
A on, B off - show just values where ColumnName = A
A off, B on - show just values where ColumnName = B
A off, B off - show nothing
Using IF( HASONEFILTER( ColumnName), COUNTROWS(etc etc), BLANK() ) enables me to achieve the last 3, but the first one (A on, B on) gives me no values. Same if I use HASONEVALUE().
If I have no wrapper function (i.e. just have COUNTROWS(etc etc) as the measure), then the first 3 work, but the last one (A off, B off) shows all the values.
Thanks in advance.
Go to Solution.
Please try this formula:
Sales measure =
ISFILTERED ( 'TableName'[ColumnName] ),
COUNTROWS ( 'TableName'),
Best regards,Yuliana Gu
View solution in original post
Check out the on demand sessions that are available now!
Check out the Winners!
Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.