Forum Discussion

qjc171819's avatar
qjc171819
Frequent Visitor
9 years ago
Solved

Top 80% Engagement

Hi guys, I have a table with Item ID and Engagement. Now i would like to create another table that shows which items that make up 80% of total engagements, also these items should desc by engagement...
Need Help
  • vanessafvg's avatar
    vanessafvg
    9 years ago

    ive never done this before but maybe this will work

     

    qjc171819

     

    engagementmeasure = sum(engagment)

     

    incrementalengagement =
    VAR CurrentEngagement = Table[engagementmeasure]
    RETURN
        SUMX (
            FILTER ( table, table[engagementmeasure] >= incrementalengagement ),
            table[enagementmeasure]
        )

     

    Table[IncrementPCT] = 

    DIVIDE (table[incrementalengagement], 

    sum (engagementmeasure))

     

     

    then based on that result theoretically you can create a table where the Table[IncrementPCT] <= 0.8

Ashish_Mathur's avatar
Ashish_Mathur
Super User
8 years ago

Hi,

 

Will this work for you?  Download the PBI file from here.

 

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Hello Ashish_Mathur,

 

the solution you provided fits to my problem. But I need to include a time filter as well.

 

I reconstructed your solution. The Ranking works. But the cumulative total doesn´t work.

 

Kumulativer Umsatz = SUMX(TOPN([Pos. Debitoren];CALCULATETABLE(VALUES(Kalender[Datum]);ALL(Kalender[Datum]));[Absoluter Umsatz]);[Absoluter Umsatz])

I add my measures to your code.

Pos. Debitoren = Rank 

Kalender[Datum] = Date 

[Absoluter Umsatz) = Total

 

Do you have an idea to solve my problem ?

 

Thanks for your help!

Christian

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Super User
    8 years ago

    Hi,

     

    Share a dataset and show the expected result.

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      Hi,

       

      thanks for your answer.

       

      Your solution works perfectly. I added the wrong columns to the mesure. So it was just my fault.

       

      Sorry for that

      Christian

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      Hi,

       

      thanks for your answer.

       

      Your solution works perfectly. I added the wrong columns to the mesure. So it was just my fault.

       

      Sorry for that

      Christian