Filter a column of table and create a measure

[smp_2022]

Hi team,

I'm new to Power BI. I have a table called Packages which has a lot of fields but 2 main fields are "Fast" (yes/no field) and "Value" (string field). I want to create a measure to filter the package table with condition "Fast" = "No" and get all values for that. How can I do that?

[Anonymous]

Hi @smp_2022 

You can create a measure like the following.

e.g 

Measure =
IF ( SELECTEDVALUE ( 'Table'[Fast] ) = "No", 1, 0 )

Then put the measure to the related visual filter, set the filter condition to that: when tehe measure is 1

e.g 

Best Regards!

Yolo Zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[JoeBarry]

Hi @smp_2022 

If you want to count all Values please try this

Amount = CALCULATE(COUNT(Packages[Values]), KEEPFILTERS([Fast] = "No"))

If you want a unique count, change COUNT to DISTINCTCOUNT

Thanks

Joe

If this post helps, then please Accept it as the solution

[smp_2022]

Hi @JoeBarry ,

The value field is a string field I don't want to count I want to get values of the "value" field where "Fast" column value = NO

[JoeBarry]

Is it a number in the Values column? Can you provide a screenshot of the Values column in Power Query? If it a number formatted as a string, then convert to number and change the Count to SUM.