Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi all.
In the picture above I have "Exec_Name" and "total" ,"Opportunity Number"and "Opportunity value". The "total" itself is a calculated table which uses the below formula:
Do i require a new calculated column as "revenue" or these adding up of the values can be done in the "total" column itself?
Solved! Go to Solution.
Hmm i think your best option would be to first create a calculated column as the formula i gave you first, then do the summary with max
Hello can you please try
Calculate([measure of revenue],allexcept(table,table[exc name]))
Hi @eliasayy . The measure of revenue is a calculated table. so when i tried using your formula it is not detecting that calculated table.
can you please try this instaed of your main measure?SUMMARIZE(ATE,ATE[Exec_name],ATE[Opportunity_Number],"total",calculate(SUM(ATE[Opportunity_value]),allexcept(table,table[exec name]))
@eliasayy Hi. Tried this:
Hmm i think your best option would be to first create a calculated column as the formula i gave you first, then do the summary with max
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
69 | |
35 | |
21 | |
18 | |
15 |
User | Count |
---|---|
127 | |
29 | |
27 | |
24 | |
22 |