Forum Discussion

jimmyhua's avatar
jimmyhua
Icon for Helper I rankHelper I
1 year ago
Solved

Conditionally Select A Table give me error message

I created two tables one is for All divisions/ entire organization and one for divisions when one division is selected.  I have a variable called DivisionFilter using HASONEVALUE to detect if a divis...
DAX help needed
Jihwan_Kim's avatar
Jihwan_Kim
Icon for Super User rankSuper User
1 year ago

Hi,

I am not sure if I understood your question correctly, but please check the below picture and the attached pbix file.

 

 

 

 

expected result measure: =
VAR _t =
    ADDCOLUMNS (
        SUMMARIZE (
            ALLSELECTED ( billing_fact ),
            division_dimension[division],
            billing_fact[billing]
        ),
        "@amount", CALCULATE ( SUM ( billing_fact[amount] ) )
    )
RETURN
    CALCULATE (
        SUM ( billing_fact[amount] ),
        KEEPFILTERS ( TOPN ( 10, _t, [@amount], DESC ) )
    )

 

  • jimmyhua's avatar
    jimmyhua
    Icon for Helper I rankHelper I
    1 year ago

    Thank you very mcuh.  it works for me.