Forum Discussion
Helper IWrong with DAX measures
shantanu97 , I checked the last file you shared You do have PL in ,'OLAP Organisation'[Statement]
Try CONTAINSSTRING -https://docs.microsoft.com/en-us/dax/containsstring-function-dax
example
Revenue = CALCULATE(SUM('OLAP CUBE_Finance_WB'[Amount]),FILTER('OLAP Organisation',CONTAINSSTRING('OLAP Organisation'[Statement],"PL")),FILTER('OLAP Account','OLAP Account'[AccountClass]="Revenue"))
1 Reply
- amitchandak
Super User
shantanu97 , I checked the last file you shared You do have PL in ,'OLAP Organisation'[Statement]
Try CONTAINSSTRING -https://docs.microsoft.com/en-us/dax/containsstring-function-dax
example
Revenue = CALCULATE(SUM('OLAP CUBE_Finance_WB'[Amount]),FILTER('OLAP Organisation',CONTAINSSTRING('OLAP Organisation'[Statement],"PL")),FILTER('OLAP Account','OLAP Account'[AccountClass]="Revenue"))