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.
Hello,
In regards to my problem I found one solution in the forum:
but unfortunatelly I could not make it work.
I have a table with a column that contains multiple business funtions that run for a specific period of time. I also have a column with the start date of each funtion and an end day.
I need so show with a visual the bussiest dates within the year by counting the business functions that "run" within the specific month. Maybe with a area chart.
I already created a graph but in those you allowed to input only one date value and not a range as you can see below.
Thank you in advance
Solved! Go to Solution.
That's the ALL in FILTER. It's cancelling the business unit filter in the legend. Just take it out. And I forgot to mention that there is no relationship between Calendar and your fact table
Measure = CALCULATE ( DISTINCTCOUNT ( Table1[Function] ), FILTER ( Table1, NOT ( Table1[Start Date] > MAX ( Calendar[Date] ) || Table1[End Date] < MIN ( Calendar[Date] ) ) ) )
Please mark the question solved when done and consider giving kudos if posts are helpful.
Cheers
Hi @Kostas
Try this measure:
Measure = CALCULATE ( DISTINCTCOUNT ( Table1[Function] ), FILTER ( ALL ( Table1 ), NOT ( Table1[Start Date] > MAX ( Calendar[Date] ) || Table1[End Date] < MIN ( Calendar[Date] ) ) ) )
Where you need a Calendar table whose MonthYear column would be used in the x-axis of your visual
Please mark the question solved when done and consider giving kudos if posts are helpful.
Cheers
Hello!
It seems that is working perfectly, I got one more question.
If in the same table have one more column that separates the business functions as categories, how I could include that in the chart as legend. I tried it with the current measure but it seems that it picks the same count of business funtions for all the Business Units.
Thank you again for your help
Kind Regards
I am sorry the picture from the graph added before is not contain the correct data in the legend.
That's the ALL in FILTER. It's cancelling the business unit filter in the legend. Just take it out. And I forgot to mention that there is no relationship between Calendar and your fact table
Measure = CALCULATE ( DISTINCTCOUNT ( Table1[Function] ), FILTER ( Table1, NOT ( Table1[Start Date] > MAX ( Calendar[Date] ) || Table1[End Date] < MIN ( Calendar[Date] ) ) ) )
Please mark the question solved when done and consider giving kudos if posts are helpful.
Cheers
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 |
---|---|
112 | |
99 | |
73 | |
72 | |
49 |
User | Count |
---|---|
145 | |
109 | |
108 | |
90 | |
64 |