Forum Discussion
daniel_baciu
Helper I
3 years agoRepeat 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...
- 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.
daniel_baciu
Helper I
3 years agoHi PiEye - no, i cannot, but i have requested it using the Request access button.
PiEye
Resolver II
3 years agoHave got the request & granted access. Let me know if you run into any more issues