Forum Discussion

gkarlo's avatar
gkarlo
Helper I
2 years ago
Solved

Filters and Cards Issues

Hi everyone.... I have two problems with one card: First:  I have a mesure that is the sum of all values of one table with all partners, however I have another table which has exclusive Partners t...
Need Help
Show and Tell
Tips and Tricks
  • MFelix's avatar
    MFelix
    2 years ago

    Hi gkarlo ,

     

    The syntax you use is HASONEVALUE this means that if you only select A you get the 0 but when you select A & B you are selecting more than one value you do not have 1 single selection so you get the 1000.

     

    In this case you should use the ISFILTERED option:

    created measure = IF(ISFILTERED('Table1'[Organization]),0, measure)

    Be aware that using this syntax if you have selected all the values it means that it's filtered so if you only want to have the values when all the organizations are selected you can redo your measure to something similar to this

    created measure = 
var _TotalOrganizations = COUNTROWS(ALL('Table1'[Organization]))
Return
IF(IF(COUNTROWS(VALUES'(Table1'[Organization])) <> _TotalOrganizations,0, measure)

     

     

    Concerning the second part of the question not sure If I understand what you want to achieve can you please give some more context.

     

Thejeswar's avatar
Thejeswar
Super User
2 years ago

Hi gkarlo ,

For the 1st question, In your DAX you are saying using HASONEVALUE() that if One Value is selected, return 0, else return 1000. This is why when more than 1 value is selected, it is returning 1000.

 

For the second question, there are few things that you need to check.

1. How is your exclusive partners table restricting the data flowing from All Partners table? One way to achieve this is to create a relation ship between Exclusive Partners to All Partner with exclusive partners filter all partners table. Your slicer should use the Exclusive Partner in your slicer. This way when select all is selected, your data coming from all partners also gets filtered to the same. 

2. We are not clear about from where the no that you are displaying in the bars is flowing. If it is flowing from all partners table, then doing step 1 will take care of it. If it is coming from a different table, we might need to have relationship between exclusive partners table and the other table from where your orders flow

 

If this doesn't solve the issue, you may have to share more information on your issue.

 

Regards,