Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

DAX - USERELATIONSHIP for slicers

Hi,   I would like to get a help on setting up a USERELATIONSHIP function to activate a slicer.   Here is my data model with 3 records only (Table name = QuantityTable). The table contains 4 col...
Need Help
Anonymous's avatar
Anonymous
Not applicable
7 years ago

Anonymous 

 

I am still not getting your requirement.

1) If you select Month=3, you want to display the "Apple" in Item slicer and Chart.

2) If no Month slicer item is selected then all fruits will be displayed in Item slicer and chart based on Order Date will be displayed.

 

Is this what you need? If yes then

 

 

Total Quantity By Order Date = CALCULATE(SUM(QuantityTable2[Quantity]),QuantityTable2[DateType] ="OrderDate")
Total Quantity By Delivery Date = CALCULATE(SUM(QuantityTable2[Quantity]),QuantityTable2[DateType] ="DeliveryDate")
TryThisMeasure = IF(ISFILTERED('Date'[Month]),SUM(QuantityTable2[Quantity]),[Total Quantity By Order Date])

 

 

Use "TryThisMeasure" instead of Quantity in Value section of Chart Visual.

 

 

Hope this resolves your issue. If yes then please mark this as Solution. Thanks

 

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Anonymous  Thank you for your reply and proposed solution.

I understand your workarounds but this is limited in certain situations, especially my real project contains over 20+ slicers similar to "items" and over 10+ "date related" columns that need to be displayed dynamically in both of the slicers and charts.

 

I tried to search from PBI community and here below posts is a reference case which is exactly the same problem to what I am currently facing:

https://community.powerbi.com/t5/Desktop/Slicer-Filters-reflect-quot-Active-quot-data-relationship-when/td-p/423632

 

Do you have any other ways to solve this problem?

Sorry to borther you again and I really appreciated your great help on this, thanks!

 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Anonymous 

     

    Solutions are provided based on the query.

    I saw the other query you provided link for and that way is not possible in current data arrangement.

     

    However you can modify your current DAX to suit my solution.

    I might guide you however I would need entire sample data with visuals arrangements to see the effect of one on other.

     

    Thanks, meanwhile if found other solution I will post here.