Forum Discussion

sraj's avatar
sraj
Icon for Responsive Resident rankResponsive Resident
3 years ago
Solved

Percent decrease in measure

Hi, Can someone please advise on this?  Probably something very silly, but I really need some input as my value in the visual is showing as '78,860,674,807' instead of what the calculator says '78,8...
Need Help
  • DOLEARY85's avatar
    DOLEARY85
    3 years ago

    Hi,

     

    try this measure:

     

    Measure 3 = calculate(sum('Table (3)'[A])*(1-0.0035))
     
    or for 0.35% use a column to transform it into the decimal number 0.0035 and replace that in the measure with the new field
     
    If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

DOLEARY85's avatar
DOLEARY85
Icon for Resident Rockstar rankResident Rockstar
3 years ago

Hi,

 

try this measure:

 

Measure 3 = calculate(sum('Table (3)'[A])*(1-0.0035))
 
or for 0.35% use a column to transform it into the decimal number 0.0035 and replace that in the measure with the new field
 
If I answered your question, please mark my post as solution, Appreciate your Kudos 👍