Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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))
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
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
99 | |
83 | |
70 | |
60 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |