Target visual

[afrutos]

Hello everyone, I would like to know how I can get the following.
On my target visual, I would like it to count me how many idobra there are based on the filter of the measure "Filter ob".
Filter ob shows me: Work Complete, Work Incomplete, D Incomplete, PL Incomplete.

So I would like the card to be able to count how many different IdObras there are for PL Incomplete.

And I can't use Filtro Ob in the Filters panel because it's a measure.

Thank you!

[PVO3]

It's hard to tell with only this information. An example file would help.

At least show the measure [Filtro Ob].

[afrutos]

I know, for me it's not posible to share the file.
this is Filtro Ob: 

Filtro Ob = SWITCH(TRUE(),

[ComprobacioD]= "Completada" && [Comprobacio PL] = "Completada", "Obra Completa",

[ComprobacioD]="Completada" && [Comprobacio PL]= "Incompleta", "PL Incompleta",

[ComprobacioD]="Incompleta" && [Comprobacio PL]= "Completada", "D Incompleta",

[ComprobacioD]="Incompleta" && [Comprobacio PL]="Incompleta", "Obra Incompleta")

[PVO3]

So there also is the measure [ComprobacioD] involved.

My first guess you have to do a COUNTX over a virtual table (SUMMARIZE/SUMMARIZECOLUMNS/CALCULATETABLE).

Something like

COUNTX( 'table', [Filtro Ob] = "PL Incompleta")

[afrutos]

Okey I want to send you  the file, how could I do this?

[PVO3 · Accepted solution]

Don't share the original file. Just create an example file with the same problem. Then upload it to some upload site and share the url with the community.

[afrutos]

this is the link:
https://app.powerbi.com/reportEmbed?reportId=ee873e67-a05a-4e05-87a8-7e029bce0b07&autoAuth=true&ctid...

[PVO3]

I think you're trying to share the report from within Power BI Service. I meant you should create a PBIX file and upload it to a site like easyupload.io or something like that.

[afrutos]

Okey, sorry, try with this!
https://easyupload.io/avk1ji

[PVO3]

Your upload has a password...

[afrutos]

I try to explai better myself;
Filtro ob tell me if my play is completed or not, and it's on a measure table.
And I have my table AUT Agrupada, which contains idobra, it's and unic id for each play.
Both tables are NOT conected.

And I need to count how many idobras there are that are PL Incomplete 

[Anand24]

@afrutos ,

Try creating a calculated column instead of calculated measure. You should be able to pull columm into filters.

Also, if you want distinct IDs, then you should use DISTINCTCOUNT instead of COUNT in your measure.

Give a Thumbs Up if this post helped you in any way and Mark This Post as Solution if it solved your query !!! Proud To Be a Super User !!! LinkedIn