Forum Discussion

Chiniminiz's avatar
Chiniminiz
Frequent Visitor
4 years ago

Filter with a variable table in a Calculate function

Hello,   we want to create an automatic ticket analyse system for internal use. The target is to receive for the top 5 categories of tickets the most used words in the short description.  We have ...
v-chenwuz-msft's avatar
v-chenwuz-msft
Community Support
4 years ago

Hi Chiniminiz ,

 

What does the formula for [Anzahl] look like?

 

Best Regards

Community Support Team _ chenwu zhu

Chiniminiz's avatar
Chiniminiz
Frequent Visitor
4 years ago

Hi v-chenwuz-msft,

 

this is a measure for distinct count the tickets. The real table has many more tickets, which shouldn't be counted. 

This is like 

DISTINCTCOUNT(Tickets[Tickets])

 

The question behind all is: Can we connect the threetables 

1. Tickets

2. Ticket-Shortdescription

3. VAR 

VAR _ServiceAndTickets = 
    ADDCOLUMNS(
        VALUES( SV_INQUIRY[IT_SERVICE] ),
        "Rank", RANKX( _ReferenceService, [Anzahl Tickets Handling User ohne PW])
    )

 

In my mind we should need a variable ranking system of the categories like 3. VAR _ServiceAndTickets which is from 1. Tickets. This we should connect to 2. Ticket-Shortdescription, because we want to get the words, per category of the top 5 categories, but in different measures, that we can get different word lists from them.

 

Do you think, this is even possible?

 

Thanks a lot für your expertise.

 

Best regards 

 

Patrick - Chiniminiz 

  • v-chenwuz-msft's avatar
    v-chenwuz-msft
    Community Support
    4 years ago

    Hi Chiniminiz ,

     

    You can try using KEEPFILTERS() to add multiple current filter contexts.

     

    Or please share your pbix file without sensitive information and with the output you want.

     

    Best Regards

    Community Support Team _ chenwu zhu