Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago
Solved

Multiply a table column with two different numbers or variable

I'm still a newby..I'm working on a project and there's something I need your help with. I need to multiply the sum total of city with 4.11 and also with 5.0. ..How do I achieve this?? I want these ...
Need Help
  • Anonymous's avatar
    Anonymous
    9 years ago

    Hi  ,

    Great Thanks for helping me..The 'Measure' you created for my slicer works perfectly. . ..  but I want to display this 'Measure' for specific month of the year. ie If I click on the 'Factory2Gas' and the Month of 'August', in the bar chart below,  I want only data for 'August' to show in the above bar chart without the chart showing the blurred part(see arrow below).  This happens when i click on specific month for either Factory1Gas or Factory2Gas.. Please Is there an edit to the Measure  or anything I can do to display this accurately..

    Problem2: Also the enitre graph  disappear (show nothing)  if I use CTRl to click both Factory1Gas and Factory2Gas together.. 

     

     

v-ljerr-msft's avatar
v-ljerr-msft
Microsoft Employee
9 years ago

Hi Anonymous,

I need to multiply the sum total of DataValueDelta with 4.11 and also with 5.0. ..How do I achieve this?? I want these values to display bar charts side by side correctly in this same bar chart. 

You should be able to simply create two measures, then show both the measures as Values on the same bar chart in your scenario. The formulas below to create the measures are for your reference. :smileyhappy:

measure1 = SUM ( 'A2011_ConfigData'[DataValueDelta ] ) * 4.11

measure2 = SUM ( 'A2011_ConfigData'[DataValueDelta ] ) * 5

 

Regards

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

     

     

     

    • v-ljerr-msft's avatar
      v-ljerr-msft
      Microsoft Employee
      9 years ago

      Hi Anonymous,

       

      If I understand you correctly, you should be able to use the formula below to create a new measure, and show this new created measure as Value on the chart. Then the measure will show value for either 'Factory1Gas' or 'Factory2Gas' according your selection on the Slicer. :smileyhappy:

      measure =
IF (
    HASONEVALUE ( 'A2011_Device'[EUA_Legend] ),
    IF (
        VALUES ( 'A2011_Device'[EUA_Legend] ) = "Factory1Gas",
        [Factory1Gas],
        [Factory2Gas]
    )
)

       

      Regards

      • Anonymous's avatar
        Anonymous
        Not applicable
        9 years ago

        Hi  ,

        Great Thanks for helping me..The 'Measure' you created for my slicer works perfectly. . ..  but I want to display this 'Measure' for specific month of the year. ie If I click on the 'Factory2Gas' and the Month of 'August', in the bar chart below,  I want only data for 'August' to show in the above bar chart without the chart showing the blurred part(see arrow below).  This happens when i click on specific month for either Factory1Gas or Factory2Gas.. Please Is there an edit to the Measure  or anything I can do to display this accurately..

        Problem2: Also the enitre graph  disappear (show nothing)  if I use CTRl to click both Factory1Gas and Factory2Gas together..