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 B is  -   IF( ColName='XYZ', COUNT(1) over ( col1, col2,col3))

3 Replies

  • 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