Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Need help in making a disconnected slicer work

Please think of a simple sales data model with appropriate facts and dimensions ( I can share a dummy model if needed).  Dimensions include a Products table, Date table, Stakeholders table, and Sale...
Need Help
  • amitchandak's avatar
    amitchandak
    4 years ago

    Anonymous , all you measures to created like this or filter this in visual level filter for non blank

     

    New measure =
    var _max = maxx(allselected(whatif),whatif[value])
    var _min = maxx(allselected(whatif),whatif[value])
    return
    IF([Total sales] > _min && [Total sales] < _max, 1 , blank()  )

     

     

    example of measures needed in table

    New sales=
    var _max = maxx(allselected(whatif),whatif[value])
    var _min = maxx(allselected(whatif),whatif[value])
    return
    IF([Total sales] > _min && [Total sales] < _max, [Total sales] , blank()  )

     

     

    count of organizations

     

    New measure =
    var _max = maxx(allselected(whatif),whatif[value])
    var _min = maxx(allselected(whatif),whatif[value])
    return
    sumx(values(Table[Organization]) ,IF([Total sales] > _min && [Total sales] < _max, 1 , blank()  ))

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

Anonymous , Use what if parameter or generateseries of table and try  measures like

 

Total sales = SUM(Sales)

 

then create a new measure

 

New measure =
var _max = maxx(allselected(whatif),whatif[value])
var _min = maxx(allselected(whatif),whatif[value])
return
IF([Total sales] > _min && [Total sales] < _max, 1 , 0 )

 

https://docs.microsoft.com/en-us/power-bi/desktop-what-if

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi amitchandak I did the same and used this measure in a chart which shows Sales by Organization and I got the right result. 
If I select all the Organizations from this widget, then every other widget (KPIs, Widgets using other dimensions such as Products) on the dashboard gets filtered out. 

Client wants this latter functionaity too without having to manually select the organization from the filtered chart. 

Edit: I get it why it was not clear from my initial question, editing it now. Sorry for the confusion!

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    4 years ago

    Anonymous , all you measures to created like this or filter this in visual level filter for non blank

     

    New measure =
    var _max = maxx(allselected(whatif),whatif[value])
    var _min = maxx(allselected(whatif),whatif[value])
    return
    IF([Total sales] > _min && [Total sales] < _max, 1 , blank()  )

     

     

    example of measures needed in table

    New sales=
    var _max = maxx(allselected(whatif),whatif[value])
    var _min = maxx(allselected(whatif),whatif[value])
    return
    IF([Total sales] > _min && [Total sales] < _max, [Total sales] , blank()  )

     

     

    count of organizations

     

    New measure =
    var _max = maxx(allselected(whatif),whatif[value])
    var _min = maxx(allselected(whatif),whatif[value])
    return
    sumx(values(Table[Organization]) ,IF([Total sales] > _min && [Total sales] < _max, 1 , blank()  ))