Visualization using measure

[Anonymous]

Hi @TomMartens,

This is in continuation to your solution in this post:

https://community.powerbi.com/t5/Desktop/Interactive-Visualization-using-measure/m-p/764375#M368345

My output worked perfectly using your solution in the above post. 

However, the users are looking for the entire data in the table visualization and want me to also show the data if the length measure and width measure are both 2.

So basically the requirments are:

1, The table visual without any filters should look like the 1st image below.

2. Now if the users selects the length in the pie chart, The table should now filter to show only the highlighted cells of the Length ( you already have provided soltuions but with your solutions we are missing our Data)

3. The card visual ( count of ID) should also be interactive. 

Is this possible? Can you help adjust your code with these requirements??

Really appreacite your kind help!

Attaching sample file with your solutions in this.

https://www.dropbox.com/s/fz74m9ixrcfuaf2/Using%20a%20measure%20to%20filter%20the%20visible%20rows%2...

For example.

user wants to see the Table Data  ---> (ID:- CCB, CDCD and KK exist)

After your proposed solution:( ID:- CCB, CDCD and KK are missing)

Many Thanks,

Tejaswi

[TomMartens · Accepted solution]

Hey @Anonymous 

if you change the code of the measure "filter the rows" to this:

filter the rows = 
var _theTable = VALUES('Weight and Length'[Weight and Length])
var _allRows = COUNTROWS(ALL('Weight and Length'))
var _check = IF(COUNTROWS(_theTable) = _allRows , 1 , BLANK())
return
SUMX(
    'Sheet1 (2)'
    , MAXX(_theTable
        , var _weightORlength = [Weight and Length]
        return
        SWITCH(
            _weightORlength
            , "Weight" , if([WeightMeasure] = 1 , 1 , _check)
            , "Length" , IF([LengthMeasure] = 1 , 1 , _check)
        )
    )
) 

the table visual will be filtered as your users want it to be filtered.

Just use the measure "filter the rows" in your card visual.

This is how it will look like:

Hopefully this is what you are looking for.

Regards,

Tom

[Anonymous]

Hi @TomMartens ,

Thank you so much..

It works as expected.

Thanks a lot and appreaciate all your help on this.

Regards,

Tejaswi