Forum Discussion
FILTER OUT null values
- 1 year ago
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.
- Anonymous1 year ago
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.
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.