Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi,
I have a simple DAX which divides one column from another.
Quote Term 2 = SUM('Case'[OppJoinHead.Quotes.Term__c]) / Count('Case'[Id])
My issue is that the Quote Term 2 Total is showing the measure of the total (64.92) where i need it to show the total value of the column (635.03). I have looked at previous posts and some videos on YT but only found solutions for Multiplications not division.
Any help is appriciated.
Dobby Libr3
Solved! Go to Solution.
Hi @Anonymous ,
Why not create a calculated column instead of measure?
Expression is as below:
Column = 'Table'[Quote - Term]/'Table'[Count]
And you will see:
Here, measure is applied in row,while calculated column is in context.
Best Regards,
Kelly
Hi Dobby -
Do you mind sharing the file (you can send it in a private message to me). I tried to replicate your situation but was unable to do so.
Regards
E
Hello, I have made a sample PBix , This is pretty much the same I just changed the COUNT in the DAX to a SUM.
Thanks E
Hi @Anonymous ,
Why not create a calculated column instead of measure?
Expression is as below:
Column = 'Table'[Quote - Term]/'Table'[Count]
And you will see:
Here, measure is applied in row,while calculated column is in context.
Best Regards,
Kelly
Hi Dobby -
Please create a new measure as explained below . If it works please let me know, I will be able to explain what's happening here.
Quote Term 3 = IF(HASONEFILTER('Table'[Index]),SUM('Table'[Quote - Term]) / COUNT('Table'[Count]),SUMX('Table',([Quote Term 2])))
Once the above is added, please add the above measure in the table visual and that should help get what you were looking for. Please let me know.
Regards
E
User | Count |
---|---|
99 | |
87 | |
81 | |
76 | |
71 |
User | Count |
---|---|
112 | |
105 | |
96 | |
74 | |
66 |