Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Calculated Column

Hi Guys,   Please refer the below  table where I have the first 2 columns in my report and the 3rd is the desired column when the Annual Usage is divided by 1000 where ever type name is Electric.  ...
Need Help
  • amitchandak's avatar
    amitchandak
    5 years ago

    Anonymous , Try a measure like

    Annual Usage (MWh) = round(CALCULATE(SUM(Deals[AnnualUsage]),FILTER(Deals,Deals[typename]="Electric"))/1000.0,0)

     

     

    Or new column like

    new column = if([typename]="Electric", round([AnnualUsage]/1000.0,0), 0) +0 

aj1973's avatar
aj1973
Icon for Community Champion rankCommunity Champion
5 years ago

Hi Anonymous 

the measure is correct if you want to see the aggregation filtered by Electric in a Card Visual not in the Table