Forum Discussion
Differential for specific values
Hi Power BI team, As usual I need your help to get this sorted. I have this table where the following fields are listed: Basically each Fare Basis value has a specific time len...
hi v-ljerr-msft,
thank you for your feedback....
i've found a solution at the end wich is: calculating every min AIF for each CXR and then making measures QF-CXR in order to highlight differentials.
Hi Anonymous,
What i need to do is creating a measure that indidicates the AIF difference between QF and others CXR for specific periods (that therefore can be selected in a time range) and class.
If I understand you correctly, the formulas below should work in your scenario. :smileyhappy:
AIF of QF = CALCULATE(SUM('EXPANDED PERIODS'[AIF]),'EXPANDED PERIODS'[CXR]="QF")
AIF of Other CXRs = CALCULATE(SUM('EXPANDED PERIODS'[AIF]),'EXPANDED PERIODS'[CXR]<>"QF")
AIF difference between QF and others CXR = [AIF of Other CXRs] - [AIF of QF]
Regards
hi v-ljerr-msft,
thank you for your feedback....
i've found a solution at the end wich is: calculating every min AIF for each CXR and then making measures QF-CXR in order to highlight differentials.