How to use Measure as a Filter in Power BI | Measure in a Slicer | Power BI Tips and Tricks (45/100)

How to use a Measure as a filter in Power BI
How to use a Measure in a Filter in Power BI
Calculated measure how to filter the value

#PowerBI #PowerBIDesktop #PowerBITutorials

💬 For Learners Post queries and Interact 💬

Complete Playlists

[CraigSwinimer]

Thank you so much for these easy instructions. I have added this to my own PBI Report and wanted to see if the upper and lower range of values in the slicer can be dynamically updated based on other slicer interactions. For example, let's say the Min and Max of the slicer values are 0 - 100. If a different slicer on the page is selected and it reduces that range of available values, (for example 0 - 20), my slicer still shows a range of 0 - 100. The values of the slicer are not dynamically updated based on other interactions. The full range of 0 - 100 shows when only 0 - 20 are available options. Thanks again for your help!

[Paleyy]

thx for the video ! the parameter-thing was exactly what I was searching for.

[andreadoro]

Hi and thanks for this video! i would like to ask a tricky question: The parameter works perfectly for the case of count or total revenue, what if a measure is a division and so a percentage? it doesn't work in the same way

[ElleneScotchbrook]

Great instruction! Where you have created the Table Filter for the slicer, can you tell me how to count the total 1's in the Table Filter and return that as a value to report on please, and thank you.

[hemantb]

Great video! I have quick question.
I wanted to use two cards showing total sales of current month and previous month after selecting current month on slicer.
Will appreciate your prompt response.

[Indian]

how to filter out specific criteria from underlying data. for example, in accessories, filter out where Order Qty is <2 . but I dont want to use the right hand bottom table, the filter has to get applied for the first table?

[karthiksharvirala]

Great Video, I learnt a lot from this, however I have a question, the measure with IF condition, throws an error for me that I can't use the column in this expression, the column inturn is a measure that divides SUM(columnA), SUM(ColumnB) from a different table. I cannot seem to understand why I can't use it as a column like you used it in your video, can you shed some light on it maybe? thank you !!!

[creativityfunzone]

I have a small doubt. I am a complete fresher. I am passionate about data analysis.I know SQL and power BI. I got a call from one MNC for power BI developer. But they are offering 3lpa. Should I go ? Any advice ?

[akhilrajoruganti]

hello sir,
i m following your power bi videos, your explanation is out standing,


Currently im learning power bi and sql
1. did power bi is data analyst or business analyst

2. As a fresher i want to know few things, that, the people who are learning power bi and sql, , do i need to learn java, c++, c

3. did we need to be prefect with one programing language
is it necessary?

4. i m going with power bi and sql, do i need to learn programing language

5. if we are going with power bi and sql? did fresher can get power bi jobs
pls tell me sir

[anuragbawankar]

can we filter Card visual in place of table ?

[BalkisIbrahim-bjmi]

can not see the table filter logic, could someone type it here