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.
Hello All,
Please help me with the below DAX formula
Target:
1. Need the client Distinct Client count. Example: A,B,C...
2. For cleints like "A" it should count the figures mentioned in column Bundle from the data format below.
Please let me know if you need further details
REgards,
chandra
Varun
Solved! Go to Solution.
Hi @Anonymous
Is this problem sloved?
If it is sloved, could you kindly accept it as a solution to close this case?
If not, please let me know.
Based on your requirements, you could create two measures
sum = CALCULATE(SUM(Table1[Bundle]),ALLEXCEPT(Table1,Table1[Client])) discount = CALCULATE(DISTINCTCOUNT(Table1[Client]),ALL(Table1))
Best Regards
Maggie
Hi @Anonymous
Is this problem sloved?
If it is sloved, could you kindly accept it as a solution to close this case?
If not, please let me know.
Based on your requirements, you could create two measures
sum = CALCULATE(SUM(Table1[Bundle]),ALLEXCEPT(Table1,Table1[Client])) discount = CALCULATE(DISTINCTCOUNT(Table1[Client]),ALL(Table1))
Best Regards
Maggie
try this
Table = SUMMARIZE(Table1,Table1[Client],"Total Bundle",SUM(Table1[Bundle]))
Hi @Anonymous,
there are many options depending on what exactly you expect.
If you need a DAX expression for creating a new table which result is a sum of bundle over client, use GROUPBY:
GroupedTable = GROUPBY ( Table1; Table1[Client]; "Sum Of Bundle"; SUMX ( CURRENTGROUP (); IF ( ISBLANK ( Table1[Bundle] ); 0; Table1[Bundle] ) ) )
If you don't care that B, C, D, and E aren't a part of the result because they are BLANK, use the default summarization of Power BI, see screenshot below.
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 |
---|---|
109 | |
99 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
87 | |
64 |