Forum Discussion

rahul_ferns's avatar
rahul_ferns
Helper II
1 year ago
Solved

Measure not populating Rows and only showing Total

Hello Experts I have a pbix with the below tables Table Names RevenueData FreightData CreditData JEData RevenueDataService Calendar Dim_Application DIM_GLAccounts ...
  • johnt75's avatar
    johnt75
    1 year ago

    First, make sure that your calendar table is marked as a date table. Also, make sure that all the relationships with the calendar table are single direction.

    Go into DAX Query view and run

    DEFINE
    VAR _Filter =
        TREATAS ( { ( 2024, "December" ) }, 'Calendar'[Year], 'Calendar'[Month] )

EVALUATE
SUMMARIZECOLUMNS (
    ROLLUPADDISSUBTOTAL ( Dim_Application[Application], "Is Total" ),
    _Filter,
    "@num days", COUNTROWS ( DATESYTD ( 'Calendar'[Date] ) )
)

    You should see the same number for each application and in the total row. If you don't then somehow a filter is getting from dim_Application to the calendar table.

johnt75's avatar
johnt75
Super User
1 year ago

First, make sure that your calendar table is marked as a date table. Also, make sure that all the relationships with the calendar table are single direction.

Go into DAX Query view and run

DEFINE
    VAR _Filter =
        TREATAS ( { ( 2024, "December" ) }, 'Calendar'[Year], 'Calendar'[Month] )

EVALUATE
SUMMARIZECOLUMNS (
    ROLLUPADDISSUBTOTAL ( Dim_Application[Application], "Is Total" ),
    _Filter,
    "@num days", COUNTROWS ( DATESYTD ( 'Calendar'[Date] ) )
)

You should see the same number for each application and in the total row. If you don't then somehow a filter is getting from dim_Application to the calendar table.

rahul_ferns's avatar
rahul_ferns
Helper II
1 year ago

Hi johnt75

That's for your support, one of the relationship was both direction and once i changed that to single it worked

Thanks for your help much appreciated