Forum Discussion

afrutos's avatar
afrutos
Icon for Resolver I rankResolver I
4 years ago
Solved

Target visual

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 o...
Need Help
  • PVO3's avatar
    PVO3
    4 years ago

    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's avatar
afrutos
Icon for Resolver I rankResolver I
4 years ago

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")
 
afrutos's avatar
afrutos
Icon for Resolver I rankResolver I
4 years ago

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's avatar
    Anand24
    Icon for Super User rankSuper User
    4 years ago

    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