Measure with multiple Filters

[Heinrich]

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

[v-eqin-msft]

Hi @Heinrich ,

Any updates?

Best Regards,
Eyelyn Qin

[v-eqin-msft]

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

[v-eqin-msft · Accepted solution]

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]

Hello Evelyn

Sorry for the late response. I was away.

Have a great time and thank you for your support.

Regards

Heinrich

[Heinrich]

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]

@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]

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]

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]

@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]

Hi tamerj1

Thank you very much.
Will test it.
Regards
Heinrich

[Heinrich]

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

[Heinrich]

Thank you I try.
Have a great day.

[Heinrich]

Hi

Do you have an example.

Thanks

Heinrich

[tamerj1]

@Heinrich 

Day_outlet_Txns =
CALCULATE (
    SUM ( [Column A1] ),
    [Column A2] = "X",
    [Column A3] > 0,
    NOT ISBLANK ( [Column A4] )
)

[tamerj1]

Hi @Heinrich 

yes possible