Forum Discussion

bensiqc's avatar
bensiqc
Helper I
3 years ago
Solved

KPI Visual - Simple Calculation

I'm building out some sample data. I have a very simple data set that looks like this:   Unit Count Spend Month Relative Month Box 1,234 $100 October Current Box 5,678 $801 Octo...
Need Help
  • vojtechsima's avatar
    vojtechsima
    3 years ago

    Hi, bensiqc , 
    I tried something real quick:

     

     

    Total Units Current = 
CALCULATE(
    [Total Units],
    'KPI'[Relative Month] = "Current"
)
    Total Units Previous = 
CALCULATE(
    [Total Units],
    'KPI'[Relative Month] = "Previous"
)
    Total Units = SUM('KPI'[Count])

     

     

     
vojtechsima's avatar
vojtechsima
Super User
3 years ago

Hi, bensiqc , 
I tried something real quick:

 

 

Total Units Current = 
CALCULATE(
    [Total Units],
    'KPI'[Relative Month] = "Current"
)
Total Units Previous = 
CALCULATE(
    [Total Units],
    'KPI'[Relative Month] = "Previous"
)
Total Units = SUM('KPI'[Count])

 

 

 
  • bensiqc's avatar
    bensiqc
    Helper I
    3 years ago

    Thanks! This works. Seems like my issue was that I didn't make an explicit Units measure and was instead using the 'sum of units' column in the dataset itself.