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.

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

  • 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" )
    ),
    "#"
)