Forum Discussion

LAndris's avatar
LAndris
Helper I
5 years ago
Solved

Measure in Matrix making Column not filter correctly.

Hi All,   I am having an issue when filtering my matrix column headers. In the Column field I have periods that are being displayed and a filter that should show filter which types of periods are b...
Need Help
  • richbenmintz's avatar
    richbenmintz
    5 years ago

    Hi LAndris,

     

    The Format Function is formatting Blanks() to an empty string, if you modify the measure to 

     

    Count_And_Average_DrillThrough = 

IF(
    SelectedValue('RPT01 02_AmountType'[AmountTypeId]) <= 100 && SUM('RPT01 01_CycleTimeReport_Amount_Row'[Amount]) <> BLANK()
    ,Format(
            CALCULATE(
                        SUM('RPT01 01_CycleTimeReport_Amount_Row'[Amount])
                    )
            ,"General Number"
            )
    ,CALCULATE(
                AVERAGE('RPT01 01_CycleTimeReport_Amount_Row'[Amount])
            )
    )

    you get the following result

     

    Now you weeks are not ordered properly, but that is a whole other issue!

     

    Thanks,

richbenmintz's avatar
richbenmintz
Resident Rockstar
5 years ago

Hi LAndris ,

 

Could you provide the definition of Measure 2 and a sample pbix?

 

Thanks,

  • richbenmintz's avatar
    richbenmintz
    Resident Rockstar
    5 years ago

    Hi LAndris,

     

    The Format Function is formatting Blanks() to an empty string, if you modify the measure to 

     

    Count_And_Average_DrillThrough = 

IF(
    SelectedValue('RPT01 02_AmountType'[AmountTypeId]) <= 100 && SUM('RPT01 01_CycleTimeReport_Amount_Row'[Amount]) <> BLANK()
    ,Format(
            CALCULATE(
                        SUM('RPT01 01_CycleTimeReport_Amount_Row'[Amount])
                    )
            ,"General Number"
            )
    ,CALCULATE(
                AVERAGE('RPT01 01_CycleTimeReport_Amount_Row'[Amount])
            )
    )

    you get the following result

     

    Now you weeks are not ordered properly, but that is a whole other issue!

     

    Thanks,