Forum Discussion

ephramz's avatar
ephramz
Icon for Helper II rankHelper II
4 years ago
Solved

Dynamic slicer for a measure

I have a measure that gives me results ranging from positive to negative values.

 

How can I create a column in a new table, all the values of this measure.

(The purpose of this is to do a dynamic slicer for the measure)

Need Help
  • v-henryk-mstf's avatar
    v-henryk-mstf
    4 years ago

    Hi ephramz ,

     

    As Greg_Deckler  said, it is not clear what your specific needs are.

     

    If you want to dynamically display the value of measure according to the slicer, you can refer to the following test:

    M = 
VAR sel =
    SELECTEDVALUE ( 'Table'[Month] )
RETURN
    CALCULATE ( SUM ( 'Table'[Quantity] ), 'Table'[Month] = sel )


    If the problem is still not resolved, please provide detailed error information and let me know immediately. Looking forward to your reply.


    Best Regards,
    Henry


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

2 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Icon for Community Champion rankCommunity Champion
    4 years ago

    ephramz So, not sure you can do that given that columns are calculated at load time and not dynamic like measures. Sorry, having trouble following, can you post sample data as text and expected output?
    Not really enough information to go on, please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882

    Also, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

    The most important parts are:
    1. Sample data as text, use the table tool in the editing bar
    2. Expected output from sample data
    3. Explanation in words of how to get from 1. to 2.

  • v-henryk-mstf's avatar
    v-henryk-mstf
    Icon for Community Support rankCommunity Support
    4 years ago

    Hi ephramz ,

     

    As Greg_Deckler  said, it is not clear what your specific needs are.

     

    If you want to dynamically display the value of measure according to the slicer, you can refer to the following test:

    M = 
VAR sel =
    SELECTEDVALUE ( 'Table'[Month] )
RETURN
    CALCULATE ( SUM ( 'Table'[Quantity] ), 'Table'[Month] = sel )


    If the problem is still not resolved, please provide detailed error information and let me know immediately. Looking forward to your reply.


    Best Regards,
    Henry


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