Forum Discussion
FILTER OUT null values
Use the Enter Data functionality to create a disconnected table which you will use in the slicer.
You can then create a measure to use as a filter
Row is visible = IF ( SELECTEDVALUE ( 'Slicer Table'[Value] ) = "All", 1, IF ( NOT ISBLANK ( [TP USD] ) && NOT ISBLANK ( [SalesPrice1] ), 1 ) )Add this as a filter to your matrix visual, to only show when the value is 1.
Hi, KaroRoza
I've simply modeled some data that hopefully fits your situation. As johnt75 says, first create a slicer table.
Measure = SWITCH(TRUE(), SELECTEDVALUE('Slicer Table'[Value])=BLANK(),1, SELECTEDVALUE('Slicer Table'[Value])="All",1, SELECTEDVALUE('Slicer Table'[Value])="Both Factory and Market"&&[TP USD]<>BLANK(),1 )Is this the result you expected?
Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Use the Enter Data functionality to create a disconnected table which you will use in the slicer.
You can then create a measure to use as a filter
Row is visible =
IF (
SELECTEDVALUE ( 'Slicer Table'[Value] ) = "All",
1,
IF ( NOT ISBLANK ( [TP USD] ) && NOT ISBLANK ( [SalesPrice1] ), 1 )
)
Add this as a filter to your matrix visual, to only show when the value is 1.
Could you please write it step by step?
What columns should I have in the table?
Create a new table with the expression
'Slicer Table' = { "All", "Both Factory and Market" }That will create a table with a single column called "Value".
Add the Value column to a slicer.
The measure should now work if you use it as a filter.