Forum Discussion

SkorpionAAM's avatar
SkorpionAAM
Helper V
6 years ago

How Can Filter function With All Funcation Thanks

Im try to get the filters with this seniro please let me know where im Wrong

nbr_related_investementFilter =
CALCULATE(distinctCOUNT(need_road_investement_coverage_details[_50kmsegement_id]),
all(need_road_station_coverage_summary[Companies]),All(need_all_station_position[operation_type]),
FILTER(need_road_station_coverage_summary ,need_road_station_coverage_summary [_nbr_related_station]>0
))
Need Help
Tips and Tricks
Tutorial Requests

3 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    6 years ago

    SkorpionAAM , seem fine. Need to what is need. Can you share sample data and sample output in table format?

     

    Unless all is not need try like

    nbr_related_investementFilter =
    CALCULATE(distinctCOUNT(need_road_investement_coverage_details[_50kmsegement_id]),
    FILTER(need_road_station_coverage_summary ,need_road_station_coverage_summary [_nbr_related_station]>0
    ))

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi SkorpionAAM 

     

    I would use the below code to count and filter.

     

     

    nbr_related_investementFilter = 
CALCULATE(DISTINCTCOUNT(need_road_investement_coverage_details[_50kmsegement_id]),need_road_station_coverage_summary[_nbr_related_station]>0))

     

     

     

     

    Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!

    Regards,
    Pranit

    • SkorpionAAM's avatar
      SkorpionAAM
      Helper V
      6 years ago

      but i want Aall funcation as well because i want to ignore this measure from master Filters