Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

PowerBi Slicer and Matrix Visualisation Issue

Hello I have a problem, where I create a Slicer(Attribute) and select multiple items to display into the Matrix table it shows me blank spaces which I do not want to see as I only want to see the the...
  • v-xuding-msft's avatar
    v-xuding-msft
    5 years ago

    Hi Anonymous ,

     

    You need to drag the measure(Subject with AND-Only Condition) into filter pane and choose "is not blank" then apply filter.

     

    Hope this can help you.

     

     

v-xuding-msft's avatar
v-xuding-msft
Community Support
5 years ago

Hi Anonymous ,

 

Please try this:

New Table as slicer:

Subject = VALUES('Table'[Subject])

A measure:

Subject with AND-Only Condition = 
var selectedSubject=VALUES(Subject[Subject])
var countRowsFact=
COUNTROWS(
    DISTINCT(
        SELECTCOLUMNS(
            FILTER(
                'Table',
                RELATED(Subject[Subject]) in selectedSubject
                ),
                "Subject",
                RELATED(Subject[Subject])
        )
    )
)
var countRowsSubject=COUNTROWS(selectedSubject)
return
IF(countRowsFact>=countRowsSubject,countRowsFact)

 

 

https://radacad.com/slicer-with-and-condition-in-power-bi#:~:text=The%20default%20behaviour%20of%20the,%E2%80%9D%2C%20OR%20%E2%80%9CBlue%E2%80%9D.

 

 

 

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Hi i tried the measure code and it does not seem to work do you know how i can resolve this issue?
 
 
  • v-xuding-msft's avatar
    v-xuding-msft
    Community Support
    5 years ago

    Hi Anonymous ,

     

    We need to create a relationship between the two tables while using RELATED function. 

     

    And based on the error message, there is an extra ")" in your formula. Please remove one to try again.

     

    I have attached my sample above. You could download it to have a try.