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,

 

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..