Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
user900
Helper II
Helper II

daxstudio to power BI conversion

This was created for me using daxstudio.  How should I revise it for Power BI to evaluate all ID's, not just on the one filtered?

 

/--Filter Report Date to start after 5/1/2023 & only Clicked
//EVALUATE
//FILTER(
//    'Table',
//    'Table'[Report Date] >= 5/1/2023 &&
//    'Table'[Click] = "True"
//    )
//
--Calculate Cumulative Sum of Primary, per User & Report Date
EVALUATE 
VAR currentdate = MAX('Table'[Report Date])
RETURN
SUMMARIZECOLUMNS(
            'Table'[Report Date],
            'Table'[Formatted Count],
            FILTER('Table','Table'[Employee ID] = "68712"),
            "ClickCount", SUMX( 
                            FILTER(
                                'Table',
                                'Table'[Report Date] <= currentdate
                                ),
                                CALCULATE( COUNTA('Table'[Employee ID))
                                )
                            )

 

Thanks in advance.

~User 900

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

@user900 , a new table 

Table=

VAR currentdate = MAX('Table'[Report Date])
RETURN
SUMMARIZECOLUMNS(
            'Table'[Report Date],
            'Table'[Formatted Count],
            FILTER('Table','Table'[Employee ID] = "68712"),
            "ClickCount", SUMX( 
                            FILTER(
                                'Table',
                                'Table'[Report Date] <= currentdate
                                ),
                                CALCULATE( COUNTA('Table'[Employee ID))
                                )
                            )

 

 

or create a measure and use the required columns in the table visual

 

SUMX(
FILTER(
'Table',
'Table'[Report Date] <= currentdate && 'Table'[Employee ID] = "68712"
),
CALCULATE( COUNTA('Table'[Employee ID))
)

View solution in original post

1 REPLY 1
amitchandak
Super User
Super User

@user900 , a new table 

Table=

VAR currentdate = MAX('Table'[Report Date])
RETURN
SUMMARIZECOLUMNS(
            'Table'[Report Date],
            'Table'[Formatted Count],
            FILTER('Table','Table'[Employee ID] = "68712"),
            "ClickCount", SUMX( 
                            FILTER(
                                'Table',
                                'Table'[Report Date] <= currentdate
                                ),
                                CALCULATE( COUNTA('Table'[Employee ID))
                                )
                            )

 

 

or create a measure and use the required columns in the table visual

 

SUMX(
FILTER(
'Table',
'Table'[Report Date] <= currentdate && 'Table'[Employee ID] = "68712"
),
CALCULATE( COUNTA('Table'[Employee ID))
)

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.