Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.

Reply
Heinrich
Post Partisan
Post Partisan

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

1 ACCEPTED SOLUTION
Anonymous
Not applicable

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.

 

Eyelyn9_0-1655968068142.png

 

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.

View solution in original post

15 REPLIES 15
Anonymous
Not applicable

Hi @Heinrich ,

 

Any updates?

 

Best Regards,
Eyelyn Qin

Anonymous
Not applicable

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
Not applicable

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.

 

Eyelyn9_0-1655968068142.png

 

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.

Hello Evelyn

Sorry for the late response. I was away.

Have a great time and thank you for your support.

Regards

Heinrich

Heinrich
Post Partisan
Post Partisan

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

@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

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" )
)

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

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

Hi tamerj1

Thank you very much.
Will test it.
Regards
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
Post Partisan
Post Partisan

Thank you I try.
Have a great day.

Heinrich
Post Partisan
Post Partisan

Hi

Do you have an example.

Thanks

Heinrich

@Heinrich 

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

Hi @Heinrich 

yes possible 

Helpful resources

Announcements
FabCon Global Hackathon Carousel

FabCon Global Hackathon

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

Check out the October 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.