anjumanj0502
New Member
- Joined
- Feb 29, 2016
- Messages
- 5
I have a CUBE in SQL from where i am getting some of the fields. I have column called forecast catgot which has multiple values like Commit, Booked, Pipeline and upside.
I wanted to create a measure where i wanted to add the total revenue of Commit and Booked into one and displayed as Total Commit.
I used the below calculation whih doesnot gives any result or any error. The whole formula appear as in one call in Itallic.
[Total_Commit]: = Calculate(Sum(Playbook_Query[Net Rev]),Filter(Playbook_Query[Forecast Category],"Commit"),Filter(Playbook_Query[Forecast Category]="Booked")
Can anyone help me on this????
I wanted to create a measure where i wanted to add the total revenue of Commit and Booked into one and displayed as Total Commit.
I used the below calculation whih doesnot gives any result or any error. The whole formula appear as in one call in Itallic.
[Total_Commit]: = Calculate(Sum(Playbook_Query[Net Rev]),Filter(Playbook_Query[Forecast Category],"Commit"),Filter(Playbook_Query[Forecast Category]="Booked")
Can anyone help me on this????