Needed Help!!! - DAX

[amar2arul]

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

[v-yulgu-msft]

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]

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]

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