Measure not calculating

[anjumanj0502]

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????

 

[barjoman]

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 don't think you need the Filter. Just use the following:

[Total_Commit]: = Calculate(Sum(Playbook_Query[Net Rev]),Playbook_Query[Forecast Category],"Commit",Playbook_Query[Forecast Category]="Booked")

 

[barjoman]

[Total_Commit]: = Calculate(Sum(Playbook_Query[Net Rev]),Playbook_Query[Forecast Category],"Commit",Playbook_Query[Forecast Category]="Booked")

Oops. Ignore that. Try this instead

[Total_Commit]: = Calculate(Sum(Playbook_Query[Net Rev]),Playbook_Query[Forecast Category]="Commit"||Playbook_Query[Forecast Category]="Booked")

 

[anjumanj0502]

Barjoman:

unfortunately it is not working. not a single formula is working when i create it as measure. I tried simple sum and that is also not working

sum: =sum(Playbook_Query[Net Rev])

Please help if you know what could be the possible reason..

 

[barjoman]

Anjumanj, what error do you get when trying sum(Playbook_Query[Net Rev])? If you hover over the yellow exclamation mark where it says error, you will see a helpful message.

My best guess is that Net Rev contains some non-numeric values.

 

[anjumanj0502]

Anjumanj, what error do you get when trying sum(Playbook_Query[Net Rev])? If you hover over the yellow exclamation mark where it says error, you will see a helpful message.

My best guess is that Net Rev contains some non-numeric values.

unfortunately i am not getting any error. Datatype for Net Revenue is Decimal Number.

 

[barjoman]

unfortunately i am not getting any error. Datatype for Net Revenue is Decimal Number.

So what exactly do you mean when you say it is not working?

 

[anjumanj0502]

I mean it is not showing any result. Only formula is getting displayed. I used the Value function to get the net revenue converted into int, but still getting the same formula.
the output which i am getting with sum: =sum(Playbook_Query[Net Rev]) is like below
sum: =sum(Playbook_Query[Net Rev])

 

[barjoman]

I mean it is not showing any result. Only formula is getting displayed. I used the Value function to get the net revenue converted into int, but still getting the same formula.
the output which i am getting with sum: =sum(Playbook_Query[Net Rev]) is like below
sum: =sum(Playbook_Query[Net Rev])

Can you please post a screenshot?

 

[anjumanj0502]

Can you please post a screenshot?

I am not able to paste the screenshot here. Could you please drop me a line on anjumanj0502@gmail.com and i will send you there