Forum Discussion
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 ...
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
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