Forum Discussion
DAX Calculation Issue from granular table to summary level DAX Statement
- 4 years ago
Hi, KarenFingerhut
I just got this thread today. It's easy to make mistakes with time-intelligence functions so it is not recommended.
Since you are using slicer, we need to build a context in the card.
Like this:
# Flag Spend > 300 Per Month = COUNTX ( SUMMARIZE ( Fuel, [InvoiceDate], [operative_name], "sum", IF ( SUM ( Fuel[GrossValue] ) > 300, 1, 0 ) ), [sum] )Did I answer your question? Please mark my reply as solution. Thank you very much.
If not, please feel free to ask me.Best Regards,
Community Support Team _Janey
Hi, KarenFingerhut
I just got this thread today. It's easy to make mistakes with time-intelligence functions so it is not recommended.
Since you are using slicer, we need to build a context in the card.
Like this:
# Flag Spend > 300 Per Month =
COUNTX (
SUMMARIZE (
Fuel,
[InvoiceDate],
[operative_name],
"sum", IF ( SUM ( Fuel[GrossValue] ) > 300, 1, 0 )
),
[sum]
)
Did I answer your question? Please mark my reply as solution. Thank you very much.
If not, please feel free to ask me.
Best Regards,
Community Support Team _Janey
Janey
I've learnt something new which will really help me with future dashbaords. Thank you 🙂
Kind regards
Karen
- v-janeyg-msft4 years ago
Community Support
Thanks for your recognition, glad you can modify the code yourself, you are smart 🤝.
Best Regards,
Community Support Team _Janey