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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Heinrich
Helper V
Helper V

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
v-eqin-msft
Community Support
Community Support

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
v-eqin-msft
Community Support
Community Support

Hi @Heinrich ,

 

Any updates?

 

Best Regards,
Eyelyn Qin

v-eqin-msft
Community Support
Community Support

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
Community Support
Community Support

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
Helper V
Helper V

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
Helper V
Helper V

Thank you I try.
Have a great day.

Heinrich
Helper V
Helper V

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
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.