How to convert/ write using following measure in Power BI?

[mdaamirkhan]

How convert/ write and used two measures following below query in my porject and also shared the pbix file; https://drive.google.com/open?id=0BxreilNC4Avsc1BkZWh0bFl5Tzg

Sales Force:

1. Measures used:

• #Teams (a Designer measure):

Sum(

            (existing [SALES LINE].[SALES LINE ID].[SALES LINE ID])

            ,Iif(IsEmpty([#Days]),null,1)

            )

• #Reps (native measure)

Time in Field %:

1. Measures used:

• %Field days (Field/working, a native measure)
• #Field Days (native measure)
• #Off Territory working days (a Designer measure):

iif(IsEmpty([Measures].[#Not Field Working days])

,0

,[Measures].[#Not Field Working days]

Can anyone help on this its urgnt.

Thanks 

Aamir

[v-ljerr-msft]

Hi @mdaamirkhan,

Could you be more precisely with the logic of these measures? Or you can just post some sample data and your expected result? So that we can better assist on this issue. 

Regards

[mdaamirkhan]

The below query  is prepared in other report but I want to prepare this Power BI

Sales Force:

1. Measures used:

• #Teams (a Designer measure):

Sum(

            (existing [SALES LINE].[SALES LINE ID].[SALES LINE ID])

            ,Iif(IsEmpty([#Days]),null,1)

            )

• #Reps (native measure)

Time in Field %:

1. Measures used:

• %Field days (Field/working, a native measure)
• #Field Days (native measure)
• #Off Territory working days (a Designer measure):

iif(IsEmpty([Measures].[#Not Field Working days])

,0

,[Measures].[#Not Field Working days]

Result screenshot below: I wan to create this measure in Power Bi and also share my pbix file link in my previous message.

 

[mdaamirkhan]

I didn't get the answer yet

[Ashish_Mathur]

Hi @mdaamirkhan,

I am willing to help but since i do not understand your Salesforce formula, i cannot understand your requirement.  PLease explain the business problem and also show the expected result.

[mdaamirkhan]

They dont share us the businnes logic with me they said that how to use the following formula in Power BI what will be the DAX of that formula. I have also shared my pbix file in  my previous replies.

[mdaamirkhan]

Any update

[mdaamirkhan]

Any update??

[KHorseman]

Nobody can help you because you can't describe the business logic. We can't write a formula if we don't know how it's supposed to work.

[mdaamirkhan]

Just convert the query

[KHorseman]

How does the query work? What do those formulas do?

[mdaamirkhan]

I have already give screenshot and pbix file

[KHorseman]

What does any of this crap mean? These are not DAX formulas.

[mdaamirkhan]

If you can't convert it into dax then say it nicely. Mind your language understand you better understand...from next time

[KHorseman]

You have to tell us how it works so we can write it in DAX. That's what we keep asking you for. Explain how you want these measures to work. What are they supposed to do?

[mdaamirkhan]

No need to help on this. 

[mdaamirkhan]

Any update

[mdaamirkhan]

any update??