Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Efficiency problem

Hi, I have an issue with the efficiency of a solution to a problem. Does anyone have improvement suggestions to improve speed? I have the basic settings in Power BI desktop, but the solution (see be...
Need Help
Tips and Tricks
  • mwegener's avatar
    mwegener
    6 years ago

    Hi Anonymous ,

     

    check this out.

    PBIX

     

     

  • v-yuta-msft's avatar
    v-yuta-msft
    6 years ago

    Anonymous ,

     

    Create an additional table using dax below:

    Account = DISTINCT('Table'[Account])

    Then create slicer based on the new 'Account' table and create measure using dax below:

    Result = 
VAR SelectedAccount = SELECTEDVALUE(Account[Account])
RETURN
CALCULATE(SUM('Table'[Sum]), FILTER(ALL('Account'), 'Account'[Account] <> SelectedAccount))

    You can also refer to pbix attached.

     

    Community Support Team _ Jimmy Tao

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

v-yuta-msft's avatar
v-yuta-msft
Community Support
6 years ago

Anonymous ,

 

Create an additional table using dax below:

Account = DISTINCT('Table'[Account])

Then create slicer based on the new 'Account' table and create measure using dax below:

Result = 
VAR SelectedAccount = SELECTEDVALUE(Account[Account])
RETURN
CALCULATE(SUM('Table'[Sum]), FILTER(ALL('Account'), 'Account'[Account] <> SelectedAccount))

You can also refer to pbix attached.

 

Community Support Team _ Jimmy Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.