Forum Discussion

Heinrich's avatar
Heinrich
Post Partisan
4 years ago
Solved

Measure with multiple Filters

Hello

I want to build a measure which gets data from a table  and uses multiple filters.

 

Here an example

 

Table A

Column A1 -> Data

Column A2 -> Filter

Column A3 -> Filter

Column A4 -> Filter

 

Is that possible.

 

Regards

 

Heinrich

Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi Heinrich ,

     

    According to this:It works but I do get 11K and not the number like 10750. Is it possible to show the whole number.

    If you used Card visual to show the measure, please go to Format pane--> Change the Display units of Value as from Thousands to None.

     

     

    Best Regards,
    Eyelyn Qin
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

15 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi Heinrich ,

     

    According to this:It works but I do get 11K and not the number like 10750. Is it possible to show the whole number.

    If you used Card visual to show the measure, please go to Format pane--> Change the Display units of Value as from Thousands to None.

     

     

    Best Regards,
    Eyelyn Qin
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

    • Heinrich's avatar
      Heinrich
      Post Partisan
      4 years ago

      Hello Evelyn

      Sorry for the late response. I was away.

      Have a great time and thank you for your support.

      Regards

      Heinrich

    • tamerj1's avatar
      tamerj1
      Community Champion
      4 years ago

      Heinrich 

      Day_outlet_Txns =
CALCULATE (
    SUM ( [Column A1] ),
    [Column A2] = "X",
    [Column A3] > 0,
    NOT ISBLANK ( [Column A4] )
)
  • Heinrich's avatar
    Heinrich
    Post Partisan
    4 years ago

    Hi

    I tried to use CQD and do the measure

     

    Day_outlet =
    CALCULATE (
    SUM ( [Audio Good Stream Count] ),
    CQD[Media Type] = "Audio",
    CQD[Packet Utilization] <> "064: [1 – 2)",
    ( CQD[QoE Record Available] = "True" )
    )



    Regards
    Heinrich

    • tamerj1's avatar
      tamerj1
      Community Champion
      4 years ago

      Heinrich 
      Is [Audio Good Stream Count] a measure or a column summarized by count? 
      If a measure please provide the code that you are using. If a column then confirm it is in the same table 'CQD'

      Thank you

      • Heinrich's avatar
        Heinrich
        Post Partisan
        4 years ago

        Hi Tamerj1

        It is a column summarized by count.

        I tested it but I do get as a resul 10K and not the whole number.
        Regards
        Heinrich

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi Heinrich ,

     

    Could you tell me if your problem has been solved? If it is, kindly Accept a helpful reply as the solution. More people will benefit from it. Or if you are still confused about it, please provide me with more details about your table and your problem or share me with your pbix file after removing sensitive data.

     

    Best Regards,
    Eyelyn Qin

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi Heinrich ,

     

    Any updates?

     

    Best Regards,
    Eyelyn Qin