Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I have a report which has Month Unit, Month Sales, Qtr Unit, Qtr Sales, Year Unit and Unit Sales.The report has slicers for Month, Qtr and Year.
The measure created for the Month sales is;
Hi @Avivek,
Please confirm if this is your expected output:
Let's say you select month JAN and FEB, year 2014 and no selection for Quarter.
Month Sales = Sales for 2014 JAN + 2014 FEB
Quarter sales = Sales for all 2014 1Q
Year Sales = Sales for all 2014
Is this what you want? If not detail further.
Regards,
Hi @Avivek ,
What about using ALLSELECTED like below:
MONTH SALES =
CALCULATE ( [Sales Amount], ALLSELECTED ( 'Date'[Month Name] ) )
Regards,
WHy not create a date calendar with Year, Quarter and Month as Columns.
Then link your date calendar to you sales table on Date column.
Then create slicers on the Year / Qrtr / Month column of the date table
It saves you the trouble of working with DAX
User | Count |
---|---|
88 | |
72 | |
68 | |
64 | |
54 |
User | Count |
---|---|
98 | |
91 | |
74 | |
68 | |
63 |