Forum Discussion

daniel_baciu's avatar
daniel_baciu
Icon for Helper I rankHelper I
3 years ago
Solved

Repeat Selected Value Across Rows In Measure

Hi,   The ultimate goal i have is to update the "Daily rate" page in the pbix model attached here, as in the picture below - ie insert the black lines and the red lines which are the yearly and the...
  • daniel_baciu's avatar
    3 years ago

    Many thanks you for the solution PiEye !

    Your proposed formulas were not exactly what i needed, but i player around a bit on them and i found the right ones.

    For Full Year this is what worked for me (i had to add " 'Dim Calendar' " to the "ALL()" expression):

     

    Value FY repeat 6 = 
    CALCULATE(
        [Value All Data k$ MTD Demo Daily],
        all('Dim Calendar'),
        'Dim Calendar'[Fiscal Year] = SELECTEDVALUE('Dim Calendar'[Fiscal Year])
    )

     

     For QTR same (i had to add " 'Dim Calendar'[Fiscal Period] " to the "ALL()" expression):

     

    Value QTR repeat 7 = 
    CALCULATE(
        [Value All Data k$ MTD Demo Daily],
        all('Dim Calendar'[Fiscal Period]),
        'Dim Calendar'[Fiscal Quarter] = SELECTEDVALUE('Dim Calendar'[Fiscal Quarter])
    )

     

    I have now the same values on the absolute numbers which i could then divide to get the right Daily numbers.