Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It 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
User | Count |
---|---|
54 | |
23 | |
19 | |
18 | |
17 |
User | Count |
---|---|
91 | |
87 | |
47 | |
28 | |
22 |