Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Measure showing error when nothing is selected in filter

Hello Community..     On my sheet I have 2 filters (cycle, survey) .. then if I am cycle by cycle 1, I want my measure to show me ​​values, if cycle 2 selection and in my survey filter I select 1s...
Need Help
  • v-jiascu-msft's avatar
    v-jiascu-msft
    8 years ago

    Hi Anonymous,

     

    There is a page level filter "ID SURVRY"[name]. So the ISCROSSFILTERED('ID SURVEY'[Name]) is always TRUE. I don't know how to get the number. Make changes to the blue part. It would work.

    MEASURE FILTER =
IF (
    ISCROSSFILTERED ( CYCLE[Cycle Name] ),
    SWITCH (
        TRUE (),
        [Filter Cycle] = "Cycle2", [Total Sales],
        [Filter Cycle] = "Cycle1", IF (
            HASONEVALUE ( 'ID SURVEY'[Name] ),
            SWITCH (
                TRUE (),
                [Filter Survey] = "Survey 1", 213480,
                [Filter Survey] = "Survey 2", 387865,
                [Filter Survey] = "Survey 3", 218488,
                [Filter Survey] = "Survey 4", 248844,
                BLANK (), 831558,
                BLANK ()
            ),
            831558
        )
    ),
    931558
)

    Best Regards!

    Dale

v-jiascu-msft's avatar
v-jiascu-msft
Icon for Microsoft Employee rankMicrosoft Employee
8 years ago

Hi Anonymous,

 

Could you please share a dummy pbix file? The relationship between two tables and the model structure should be considered. 

 

Best Regards!

Dale

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    someone can help me, I can not do what works the way I want... thx guys

    • v-jiascu-msft's avatar
      v-jiascu-msft
      Icon for Microsoft Employee rankMicrosoft Employee
      8 years ago

      Hi Anonymous,

       

      There is a page level filter "ID SURVRY"[name]. So the ISCROSSFILTERED('ID SURVEY'[Name]) is always TRUE. I don't know how to get the number. Make changes to the blue part. It would work.

      MEASURE FILTER =
IF (
    ISCROSSFILTERED ( CYCLE[Cycle Name] ),
    SWITCH (
        TRUE (),
        [Filter Cycle] = "Cycle2", [Total Sales],
        [Filter Cycle] = "Cycle1", IF (
            HASONEVALUE ( 'ID SURVEY'[Name] ),
            SWITCH (
                TRUE (),
                [Filter Survey] = "Survey 1", 213480,
                [Filter Survey] = "Survey 2", 387865,
                [Filter Survey] = "Survey 3", 218488,
                [Filter Survey] = "Survey 4", 248844,
                BLANK (), 831558,
                BLANK ()
            ),
            831558
        )
    ),
    931558
)

      Best Regards!

      Dale

      • Anonymous's avatar
        Anonymous
        Not applicable
        8 years ago

        v-jiascu-msft Your are the best!!! Thx so much, really, really this solution was amazing :D

         

        Thx for ur help and time Dale.