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.
I created a Chart that is comparing a count of value from selected year to the last and the difference
I also have a card that is giving me the value of the difference
I am trying to find a way to take the difference value measure and turn into an average per day. But the day would be based on slicer selection ( 'Calendar' [Date] )
Any Suggestions ?
I would also like to show a per hour number as well
Thanks
Solved! Go to Solution.
To be general, you can create two measures like pattern below and drag the measures to the card chart.
Measure based on selection = CALCULATE ( [average], FILTER ( Table, Table[Date] = SELECTEDVALUE ( Table[Date] ) ) ) Measure based on per hour = CALCULATE ( [average], FILTER ( Table, HOUR ( Table[Time] ) = HOUR ( EARLIER ( Table[Time] ) ) ) )
Community Support Team _ Jimmy Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
To be general, you can create two measures like pattern below and drag the measures to the card chart.
Measure based on selection = CALCULATE ( [average], FILTER ( Table, Table[Date] = SELECTEDVALUE ( Table[Date] ) ) ) Measure based on per hour = CALCULATE ( [average], FILTER ( Table, HOUR ( Table[Time] ) = HOUR ( EARLIER ( Table[Time] ) ) ) )
Community Support Team _ Jimmy Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
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 |
---|---|
115 | |
100 | |
88 | |
68 | |
61 |
User | Count |
---|---|
152 | |
120 | |
102 | |
87 | |
68 |