Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi !!
I've a Page with Relative Date filter.
Into one graphic I've Hotel Occupancy Measure (I've paste Measure Code)
OcupacionMensual = var pHO = CALCULATE(SUM(EstadGeneral[HO]), 'Date'[Date]) var pHA = CALCULATE(sum(EstadGeneral[HA]), 'Date'[Date]) var pRR = DIVIDE(pHO, pHA) * 100 VAR result = INT(ROUND(pRR,0)) return result
Into Other Measure, I've the same calculation, but Same Period Last Year.
OcupacionMensualSPLY = var pHO = CALCULATE(SUM(EstadGeneral[HO]), DATEADD('Date'[Date],-1,1,YEAR)) var pHA = CALCULATE(sum(EstadGeneral[HA]), DATEADD('Date'[Date],-1,1,YEAR)) var pRR = DIVIDE(pHO, pHA) * 100 VAR result = INT(ROUND(pRR,0)) return result
My problem is when I put two measures into the same graphic, I can't see into the same graph, because the graph are filter with Relative date.
It's possible to solve that and see into the same graph both measures?
Instead of relative date filter, you may add filter arguments in CALCULATE as well.
User | Count |
---|---|
141 | |
113 | |
104 | |
78 | |
64 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |