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'm sorry this is such a simple question, but I can't figure it out from googling. Can someone help me with following?
I have a table with daily actions against a table with contract maximums per month. I'm trying to create a table that lists customers that have exceeded their allowable question limit per month. In summary:
Where I have:
Questions submitted (daily) in Daily_Feed
Allowable questions per month in Client_Lookup
Calendar_Lookup table
I need to do something like:
1. Sum daily questions per client per month.
2. Flag where the sum of questions per month exceeds the allowable questions per month in the Client_Lookup.
I can obviously do step 1 visually using a table, but that won't allow me to do step 2.
Your help would be hugely appreciated!!
Solved! Go to Solution.
Hi @tinkertrust,
Please refer to below measures:
daily questions per client per month = CALCULATE ( COUNT ( Daily_Feed[Question] ), ALLEXCEPT ( Daily_Feed, Daily_Feed[Client], Daily_Feed[Date].[MonthNo] ) ) allowable questions per month = CALCULATE ( SUM ( Client_Lookup[Allowable questions] ), FILTER ( Client_Lookup, Client_Lookup[Client] = SELECTEDVALUE ( Daily_Feed[Client] ) && Client_Lookup[MonthNo] = SELECTEDVALUE ( Daily_Feed[Date].[MonthNo] ) ) ) flag = IF ( Daily_Feed[daily questions per client per month] > [allowable questions per month], "exceed", BLANK () )
Best regards,
Yuliana Gu
Hi @tinkertrust,
Please refer to below measures:
daily questions per client per month = CALCULATE ( COUNT ( Daily_Feed[Question] ), ALLEXCEPT ( Daily_Feed, Daily_Feed[Client], Daily_Feed[Date].[MonthNo] ) ) allowable questions per month = CALCULATE ( SUM ( Client_Lookup[Allowable questions] ), FILTER ( Client_Lookup, Client_Lookup[Client] = SELECTEDVALUE ( Daily_Feed[Client] ) && Client_Lookup[MonthNo] = SELECTEDVALUE ( Daily_Feed[Date].[MonthNo] ) ) ) flag = IF ( Daily_Feed[daily questions per client per month] > [allowable questions per month], "exceed", BLANK () )
Best regards,
Yuliana Gu