Forum Discussion

a-simarg's avatar
a-simarg
Icon for Helper II rankHelper II
7 years ago
Solved

Calculate the Percentage

Hi

Can someone help me with bellow?

I have a table with 2 columns:

Modality           Clicks

chat                    123

bot                      23456

online                  41

submission          2456

Total                  26076

 

Now i want to calculate for each modality using visualization "card" the percentage for each from the total

Example: chat - 0.47%; Bot 89.9%

 

Thanks

 

 

Need Help
Show and Tell
Tips and Tricks
  • Arentir's avatar
    Arentir
    7 years ago

    Hi a-simarg

    If you use card, then you will need a visual level filter for each of your card. 

    Your value can be this measure:

    Measure = SUM(Table1[Clicks]) / CALCULATE(SUM(Table1[Clicks]),ALL(Table1))

     

    You don't need to use total field, the calculate part will do that for you

10 Replies

  • Arentir's avatar
    Arentir
    Icon for Resolver III rankResolver III
    7 years ago

    Hi a-simarg

    If you use card, then you will need a visual level filter for each of your card. 

    Your value can be this measure:

    Measure = SUM(Table1[Clicks]) / CALCULATE(SUM(Table1[Clicks]),ALL(Table1))

     

    You don't need to use total field, the calculate part will do that for you

    • a-simarg's avatar
      a-simarg
      Icon for Helper II rankHelper II
      7 years ago

      the percenatge works but now when i choose different months the percentage remains the same for every months..

      • Anonymous's avatar
        Anonymous
        Not applicable
        7 years ago

        Looks like the filters are not propogating correctly.

         

        Can you provide screenshots?

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    You can use the in-built feature.

    • a-simarg's avatar
      a-simarg
      Icon for Helper II rankHelper II
      7 years ago

      This only worked!

      thakns a lot

      you are awsome!

    • a-simarg's avatar
      a-simarg
      Icon for Helper II rankHelper II
      7 years ago

      It is true yes, but when you filter , and choose for example Modality Chat, what percentage shows you?

      • Anonymous's avatar
        Anonymous
        Not applicable
        7 years ago

        You are correct, a measure is better.

        a-simarg wrote:

        It is true yes, but when you filter , and choose for example Modality Chat, what percentage shows you?