Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi all, please help me for solution.
kindly see the data set . there is cycle column with Q1,Q2,Q3. with ID , Amount column
I need difference of two cycle (which i'm selecting in filter) higher cycle will be base in difference
i attached dax, power bi view images also.
Dax which previously tried showing the difference(q3-q2-q1) which is working while im selecting q3 and q2 or q3 and q1.
but if im selecting q2 and q1 in filter . it should show q2 - q1 as answer. but this dax showing ( -q2-q1). here q2 should be base in difference.
please help me out ?
highly appreciate for solution
Hi @Xiaoxin Sheng , Thanks for your reply, But I need difference , should be in dynamic calculation in accordance with filter selection.
Thanks a lot for your further reply
can you please help me in this?
HI @sarath_chandra,
According to your description, it seems like you want to measure calculate with multiple aggregations.
For this scenario, I'd like to suggest you refer to Greg’s blog to use summarize function to apply the first level aggregation and use iterator function sumx to apply the second level aggregate.
Measure Totals, The Final Word
Regards,
Xiaoxin Sheng
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
105 | |
97 | |
79 | |
66 | |
62 |
User | Count |
---|---|
145 | |
113 | |
105 | |
85 | |
65 |