Forum Discussion
Filters and Cards Issues
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.
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.
Thanks Felix, that was helpful and it worked properly 🙂.
Related to the second issue, the Filter that I have, it comes from Table Organization (exclusive Partners-EP) and it has a relation connection with the main table in order to Filter by EP.
However, when any value is selected, the graphic show all total orders from all Partners, and that is okay as you can see in picture 1. However, when the Filter Exclusive-Partner is as "Selected All", the graph's values doesn't change anything as Pic-2. But when I select one by one all values from the Filter, I get the right values that should be shown on the graphic. Pic-3.
*Hint: The Exclusive Partner Filter has a behind filter to hide Blank option, that is for the relation between tables cause I don't like to show that option on the slicers, in case not find a solution, I wonder if there is an option to rename Blank as i"Normal Partners".