Forum Discussion

jussiwaisto's avatar
jussiwaisto
Helper I
6 years ago
Solved

Easy € per sum, how do I do it?

Hi, I have a simple question: how do I make a measure by this situation?   Table name = Table1 id € 1 100 2 200 3 300 4 400 5 500 6 600 7 700 8 800     S...
Need Help
Show and Tell
  • amitchandak's avatar
    amitchandak
    6 years ago

    For each measure in a visual, you have the option to show it has % of the total. Right-click and check.

    In case you want to calculate 

     

    Ratio =
Var Overall = calculate(sum( €),all(table1))
return
calculate(divide(sum(€),[Overall]))

     

     

amitchandak's avatar
amitchandak
Super User
6 years ago

For each measure in a visual, you have the option to show it has % of the total. Right-click and check.

In case you want to calculate 

 

Ratio =
Var Overall = calculate(sum( €),all(table1))
return
calculate(divide(sum(€),[Overall]))

 

 

jussiwaisto's avatar
jussiwaisto
Helper I
6 years ago

Thank you amitchandak! It seems to work almost right, but it seems that I should use some date function there also.

 

There is also a column (Date) and now this counts everything.

 

I have a date slider and now I would like to include that slider dates into the results.

 

 

Do I have to add some date syntax there also?