Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hi Team
I am trying to create 3 meaures -
Measure 1 in which user can see sum of values on the basis of selection month_modified_1
Measure 2 in which user can see sum of values on the basis of selection month_modified_2
Measure 3 in which user can see variance between measure1 and measure2
The problem which I am facing I have 2 slicers of month_modified_1 and month_modified_2 - both must have same month selected only then it is showing data otherwise not - the whole purpose of keeping these 2 columns are going in vain as I want to give user to select a month in both slicers to ignore each other and show respective sum of the values and variance.
I have tried below and many ways of dax but nothing is working
Please help as I am unable to upload the file here?
Solved! Go to Solution.
Hi, @RatanBhushan_05
You can try the following methods to create a new date table.
Date = VALUES(Sheet1[Month_Modified_2])
Measure 1 = SUM(Sheet1[Value])
Measure 2 =
CALCULATE ( SUM ( Sheet1[Value] ),
FILTER ( ALLEXCEPT ( Sheet1, Sheet1[Attribute] ),
[Month_Modified_2] = SELECTEDVALUE ( 'Date'[Month_Modified_2] )
)
)
Difference = [Measure 2]-[Measure 1]
Is this the result you expect?
Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi, @RatanBhushan_05
You can try the following methods to create a new date table.
Date = VALUES(Sheet1[Month_Modified_2])
Measure 1 = SUM(Sheet1[Value])
Measure 2 =
CALCULATE ( SUM ( Sheet1[Value] ),
FILTER ( ALLEXCEPT ( Sheet1, Sheet1[Attribute] ),
[Month_Modified_2] = SELECTEDVALUE ( 'Date'[Month_Modified_2] )
)
)
Difference = [Measure 2]-[Measure 1]
Is this the result you expect?
Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
User | Count |
---|---|
25 | |
11 | |
8 | |
6 | |
6 |
User | Count |
---|---|
30 | |
13 | |
11 | |
9 | |
6 |