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.
My table contain the Year, Halfyear, Quarter, Month as seperate columns. I want to obtain a count DAX wherein if selected value is any quarter then count should be 3, any halfyear then 6, any month then 1 and 12 for the year. Also, if im changing the selection where in if i selected H1 and i untick one of the month below it then it should be count of remaining months ex 5 if one of the month is unselected. Below is the sample of the filter i will be using.
Solved! Go to Solution.
Hi @nareshr89
you can use SWITCH over TRUE for ISINSCOPE
tou need to start from the smallest to the largest period.
Hi @nareshr89
you can use SWITCH over TRUE for ISINSCOPE
tou need to start from the smallest to the largest period.
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 |
---|---|
47 | |
24 | |
20 | |
15 | |
13 |
User | Count |
---|---|
55 | |
48 | |
43 | |
19 | |
19 |