Dynamic filter dax

[Anonymous]

Hello everyone, 

I'm working on a dax measure to return multiple text values, using certain management rules which are based on certain interactions of filters. 

so the management rule works as follows:

I have filters that are on the left of the page, so to start some filters must be selected, as you see in the image below mentioned in blue.

Once these filters are selected, the filters on the right must display data, otherwise, these filters must not display anything (they display blank) if the condition of the filters on the left is not met. 

Below, is the dax I did to get a result but I can't! help me, please. 

Measure : ISFILTERED(DIVISIONS[option1])&&ISFILTERED(ARTICLES[article])&&ISFILTERED('SQC_MEASURE'[class])&&SELECTEDVALUE('SQC_MEASURE'[option2],"Multi")<>"Multi"&&SELECTEDVALUE(ARTICLES[articles],"Multi")<>"Multi"&&SELECTEDVALUE('SQC_MEASURE'[class],"Multi")<>"Multi"&&DISTINCTCOUNT('SQC_MEASURE'[class])=1,

        LASTNONBLANK(SQC_MEASURE[name of characteristic],""),

        BLANK()

        )

[Anonymous]

Hello everyone, 

I'm working on a dax measure to return multiple text values, using certain management rules which are based on certain interactions of filters. 

so the management rule works as follows:

I have filters that are on the left of the page, so to start some filters must be selected, as you see in the image below mentioned in blue.

Once these filters are selected, the filters on the right must display data, otherwise, these filters must not display anything (they display blank) if the condition of the filters on the left is not met. 

Below, is the dax I did to get a result but I can't! help me, please. 

Measure : ISFILTERED(DIVISIONS[option1])&&ISFILTERED(ARTICLES[article])&&ISFILTERED('SQC_MEASURE'[class])&&SELECTEDVALUE('SQC_MEASURE'[option2],"Multi")<>"Multi"&&SELECTEDVALUE(ARTICLES[articles],"Multi")<>"Multi"&&SELECTEDVALUE('SQC_MEASURE'[class],"Multi")<>"Multi"&&DISTINCTCOUNT('SQC_MEASURE'[class])=1,

        LASTNONBLANK(SQC_MEASURE[name of characteristic],""),

        BLANK()

        )

[V-lianl-msft]

Hi @Anonymous ,

Is the slicer or filter mentioned in your picture?Measure cannot be used as a slicer. You can create a measure and apply it to the slicer's visual level filter.

Sorry, I don't know what you expect,Please provide sample data and the results you expect.

https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523 

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Anonymous , Create measure

filtered = if(isfiltered(Table[Column]),1,0)

and check in other slicers in the visual level filter that it is 1

[v-chenwuz-msft]

Hi @Anonymous ,

You can try to use 1 for true instand of LASTNONBLANK() in IF() result.

Measure =
IF(
    ISFILTERED( DIVISIONS[option1] ) && ISFILTERED( ARTICLES[article] )
        && ISFILTERED( 'SQC_MEASURE'[class] )
        && SELECTEDVALUE( 'SQC_MEASURE'[option2], "Multi" ) <> "Multi"
        && SELECTEDVALUE( ARTICLES[articles], "Multi" ) <> "Multi"
        && SELECTEDVALUE( 'SQC_MEASURE'[class], "Multi" ) <> "Multi"
        && DISTINCTCOUNT( 'SQC_MEASURE'[class] ) = 1,
    1,
    BLANK()
)

And set the filters on this slicer visual as show items when the value is 1.

Pbix in the end you can refer.

Best Regards

Community Support Team _ chenwu zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.