Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
99 | |
83 | |
70 | |
60 |
User | Count |
---|---|
150 | |
115 | |
104 | |
89 | |
65 |