Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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)
Solved! Go to Solution.
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.
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.
@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.
User | Count |
---|---|
96 | |
85 | |
77 | |
66 | |
63 |
User | Count |
---|---|
110 | |
95 | |
95 | |
64 | |
59 |