Forum Discussion
How to create dynamic measures that updates when drilling down in data?
Thanks :)
That's what I thought also, but it would be great to be able to have the drill down filter on the page level instead of only visual, or at least to have the ability to configure the behaviour we need for each report/dashboard.
I see there is an existing idea about that, I'll put some votes on it :)
Hi
Everone
I was creating a new mesure, but i have this error "The syntax for ':' is incorrect. (DAX(
IF( SUM(AHT[Tiempo Retiradas Almuerzo]) - SUM(AHT[Tiempo Objetivo de Almuerzo]) = 01:00:00. 0 ,SUM(AHT[Tiempo Retiradas Almuerzo]) - SUM(AHT[Tiempo Objetivo de Almuerzo]))
)).", i need to do a subtration of Time 1 ( Retiradas) - Time 2 ( Time Obj), and i have a result 01:00:00(hh:mm:ss), it show me thta person dont have time of lunch, i wnat to use IF to put off( 01:00:00) for 0.
Somebody can help me?
Thanks!
Raulpt27, you should create your own thread rather than bringing up unrelated topics in the responses of someone else's.
That being said, if you have a field where the value is 01:00:00.0, then that is a text value. You need to enclose text literals with double quotes "01:00:00.0". That will get rid of the syntax error. The next problem you'll have is that this is a text string, so you can't do arithmetic on it. You'll need to store your durations as numeric types - integers or floats - whole number and decimal in Power Pivot's data types.