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 -> Fi...
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.

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

tamerj1's avatar
tamerj1
Community Champion
4 years ago

Hi Heinrich 
Please try

Day_outlet =
CALCULATE (
    COUNT ( CQD[Audio Good Stream] ),
    CQD[Media Type] = "Audio",
    CQD[Packet Utilization] <> "064: [1 – 2)",
    ( CQD[QoE Record Available] = "True" )
)
  • Heinrich's avatar
    Heinrich
    Post Partisan
    4 years ago

    Great Tamerj1

    It works but I do get 11K and not the number like 10750.

    Is it possible to show the whole number.

    Regards
    Heinrich

    • tamerj1's avatar
      tamerj1
      Community Champion
      4 years ago

      Heinrich 
      Try

      Day_outlet =
FORMAT (
    CALCULATE (
        COUNT ( CQD[Audio Good Stream] ),
        CQD[Media Type] = "Audio",
        CQD[Packet Utilization] <> "064: [1 – 2)",
        ( CQD[QoE Record Available] = "True" )
    ),
    "#"
)
      • Heinrich's avatar
        Heinrich
        Post Partisan
        4 years ago

        Hi tamerj1

        Thank you very much.
        Will test it.
        Regards
        Heinrich