cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Regular Visitor

## Filter or virtual table

I have a measure where I calculate a percentage, I need to count the records that have a percentage greater than or equal to 80 but

I can't do this filter and count all the measures that I try do not return the items as if I didn't identify which ones have this value.

vM80 =
CALCULATE(
DISTINCTCOUNT([CO_MUNICIPIO]),
)

2 ACCEPTED SOLUTIONS
Community Champion

Don't have enough info about your model, but just by looking at your measure, try to replace it with:

vM80 =
CALCULATE(
DISTINCTCOUNT([CO_MUNICIPIO]),
)

it as if you will write:

vM80 =
CALCULATE(
DISTINCTCOUNT([CO_MUNICIPIO]),
)
which is different substentially than what you wrote so maybe it will solve your problem quickly
Regular Visitor

I tried it before but it didn't work

13 REPLIES 13
Regular Visitor

Good afternoon, I managed to solve it was a relationship problem between the dimensions

Regular Visitor

I managed to solve it, THANK YOU ALL

Community Support

Hi  @hugors ,

I created some data:

Here are the steps you can follow：

1. Create measure.

``````Flag =
IF(
[CV %] >=80,1,0)``````
``````discount =

2. Place [Flag]in Filters, set is=1, apply filter.

3. Result:

If I have misunderstood your meaning, please provide your pbix file without privacy information and desired output.

Best Regards,

Liu Yang

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

Regular Visitor

The solution is interesting but it didn't work either, I'm believing that it may be an association problem between the models. I keep trying, thanks for the help

Community Champion

Try:

``````vM80 =
CALCULATE ( DISTINCTCOUNT ( 'Table'[CO_MUNICIPIO] ), FILTER ( F_Dados, [CV %] >= 80 ) )
``````

Change 'Table' to whatever table the [CO_MUNICIPIO] is in

In doing so, you are also helping me. Thank you!

Proud to be a Super User!

Regular Visitor

I tried it before but it didn't work

Regular Visitor

Thanks for the answer, but in the count it returns the total of rows as a result and not just the rows that have the "CV %" greater than or equal to 80

Community Champion

Don't have enough info about your model, but just by looking at your measure, try to replace it with:

vM80 =
CALCULATE(
DISTINCTCOUNT([CO_MUNICIPIO]),
)

it as if you will write:

vM80 =
CALCULATE(
DISTINCTCOUNT([CO_MUNICIPIO]),
)
which is different substentially than what you wrote so maybe it will solve your problem quickly
Regular Visitor

A 'PLACEHOLDER' function was used in a True/False expression used as a table filter expression. This is not allowed.

Community Champion

Yes, because it's a measure. Your code had a table name before that, which indicates that its a column :).

It won't work in the way I wrote it if "c_CV Geral is a measure .

Regular Visitor

Yes, it is a measure I can forward the file, do you have an email

Super User

Hi,

Regards,
Ashish Mathur
http://www.ashishmathur.com
Regular Visitor

Thanks for the answer, but, when trying to use the measure as proposed, it returns the message "It is not possible to find the column 'c_CV Geral' in the table 'F_Dados' or it is not allowed to use it in this expression" only reinforcing the column "c_CV Geral" is a calculated measure, I changed the column "c_CV Geral" for a fixed one, but it always returns 1 for all rows

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

#### Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

#### New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

Top Solution Authors
Top Kudoed Authors