Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Measures with Date Tables

Hi,   I am very new to Power BI and I am having trouble using a measure with a date table.   I created a date table for looking up Dates = CALENDAR(TODAY()-1000,TODAY()+1000)   within which I ...
Need Help
  • parry2k's avatar
    parry2k
    7 years ago

    Anonymous sorry missed a bracket

     

    SLA % = 
VAR d = 
DIVIDE (
  SUM ( Table1[Incident Breached] ),
  SUM ( Table1[Count])
)
RETURN
IF (ISBLANK(d), BLANK(),1-d)
parry2k's avatar
parry2k
Icon for Super User rankSuper User
7 years ago

Anonymous did you setup relationship between your date and transaction table?

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Wow, that was quick :-)  Thanks for getting back to me parry2k 

     

    Yes, I think(?) I have

    Here you can see two charts, both are using the same MonthYear axis 

    But the one in the left (which does not use a measure) seems to work fine.

    • mussaenda's avatar
      mussaenda
      Icon for Community Champion rankCommunity Champion
      7 years ago

      try setting your relationship direction to both

      • parry2k's avatar
        parry2k
        Icon for Super User rankSuper User
        7 years ago

        Anonymous problem is your measure is returning 1 when there is no value in divided by and that's why you are seeing all the dates. I wouldn't recomment to set the relationship to both direction since it can have performances issue on large dataset.

         

        try following

         

        SLA % = 
VAR d = DIVIDE (
SUM ( Table1[Incident Breached] ),
SUM ( Table1[Count])
RETURN
IF (ISBLANK(d), BLANK(),1-d)