Forum Discussion

arvindyadav's avatar
arvindyadav
Post Partisan
9 years ago

Regarding Extended Pro Trail.

Hi,   A month ago i was available for extended pro trail but now i am only available for 60 days trail pack. Please help me out what actually happens.
Need Help
v-yulgu-msft's avatar
v-yulgu-msft
Microsoft Employee
9 years ago

Hi arvindyadav,

 

So, currently, you can use the Entended Pro Trail successfully, right? If so, would you please kindly mark the corresponding reply as an answer? If you still have any question, please feel free to ask.

 

Regards,
Yuliana Gu

arvindyadav's avatar
arvindyadav
Post Partisan
9 years ago

Hi @Yuliana ,

 

This is very needy things which I want so badly.

can you please solve this issue .

The issue is when I publish my desktop work in Power BI service then my measure value is same as what I got in Desktop version but when I refresh in Power Bi service the value changes with increment of one. Which is wrong .

 

please Find the attached with my used formula .

In the both attached please find june month then you will got the error.

There are two attached one of desktop version another of Power Bi Service.

 

 

The Mine formula i.e, 

Productive Calls = CALCULATE(DISTINCTCOUNT(Query1[booked_order_id])) - CALCULATE(

DISTINCTCOUNT('Query1'[booked_order_id]),

'Query1'[booked_order_id] IN { 0 }

)

Give me the value excluding zero.

 

 

1. The outcome of the formula below is 0.

CALCULATE(
DISTINCTCOUNT('Query1'[booked_order_id]),
'Query1'[booked_order_id] IN { 0 }

 So from total distinct count of book order id I have count every value excluding Zero so that is the why I am using the formula

 

Productive Calls = CALCULATE(DISTINCTCOUNT(Query1[booked_order_id])) - CALCULATE(

DISTINCTCOUNT('Query1'[booked_order_id]),

'Query1'[booked_order_id] IN { 0 }

 

which give me distinct count excluding zero.

 

Regards ,

Arvind

  • v-yulgu-msft's avatar
    v-yulgu-msft
    Microsoft Employee
    9 years ago

    Hi arvindyadav,

     

    I will take a look at this problem. But, since this is a different question from original one, personally, you'd better post this question as a new thread in forum so that it can get more attention and help from community members.

     

    Regards,
    Yuliana Gu

    • arvindyadav's avatar
      arvindyadav
      Post Partisan
      9 years ago

      Hi @Yuliana,

       

      Please try if possible from your sides and solve because its so needy work for me now.

      Thanks in advance.

       

      Regards,

      Arvind

       

       

    • arvindyadav's avatar
      arvindyadav
      Post Partisan
      9 years ago

      Hi Yuliana,

       

      I got the added measure answer from @dale.

      I want to know from your side that when will be "what if" analysis come into the picture?

       

      Regards,

      Arvind