Forum Discussion

amar2arul's avatar
amar2arul
Frequent Visitor
8 years ago

Needed Help!!! - DAX

 I am trying to replicate the DAX syntax in Power BI . the formulae written in Spot fire is    SUM(A/B)/Uniquecount( If ( ColName='XYZ',ColB)),0)   Where A  - is a direct column in table   and ...
v-yulgu-msft's avatar
v-yulgu-msft
Microsoft Employee
8 years ago

Hi amar2arul,

 

I am not able to understand above query used in Spot fire. Please post some dummy data to show us what original dataset is and what your desired output is. Besides, please illustrate the calculation rule to help us better understand your requirement.

 

Regards,

Yuliana Gu

amar2arul's avatar
amar2arul
Frequent Visitor
8 years ago

Hi,

 

Sure..

 

Spotfire formula is :  

 

result = SN(  SUM ( Column X  /  Column Y ) /  uniquecount( IF( Column Z=  "Sample Text" ,  Column A ) ) , 0) 

 

*** Where Coluym Y =    IF (  column B= "Sample Text". Count(1) OVER  (Column C, Column D, Column E ) )

 

 

So i need the Result value formulae in Power BI

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

    Hi amar2arul,

     

    Sorry, I'm not familiar with Spotfire formula. What I want to know is original data, and based on this data, what do you want to achieve? Please illustrate with sample data.

    How to Get Your Question Answered Quickly

     

    Regards,

    Yuliana Gu