Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

A filter challenge...

Hi all, I have a filter challenge. So...the situation:   I have TABLE_1 which contains a column REGISTER_SIZE - this shows how many people are registered at each location (with each location having...
Need Help
  • JosefPrakljacic's avatar
    JosefPrakljacic
    6 years ago

    You need to write a Measure like these one here

     

    ListSizeMeasure :=
CALCULATE ( SUM ( LIST_SIZE[PRACTICE_LIST_SIZE] ), ALL ( sales ) )

    The other problem you still need to resolve are your relationships. Try to achieve a 1:* Relationship - I can't help you here because I don't know your data.

     

    Here you have a working example file. As you can see I'm filtering with the Geograpthy table and the sales part is not intervening.

     

     

    If this post was helpful please kudo it and mark it as the solution.

     

    Have a nice day Lewdow!

     

    BR,

    Josef

mussaenda's avatar
mussaenda
Community Champion
6 years ago

Allexcept can help you.

 

You can provide a sample data and your desired output to help you better.

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago
    Looks just what I need. How do I apply DAX to a standard multirow card visual?
    • v-frfei-msft's avatar
      v-frfei-msft
      Community Support
      6 years ago

      Hi Anonymous ,

       

      Kindly share your sample data and excepted result to me if you don't have any Confidential Information. Please upload your files to One Drive and share the link here.

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        Hi v-frfei-msft , thanks - a sample file can be found here - any bright ideas would be appreciated! Thanks.