Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi to all,
i have a question about a measure to calculate grand total with particular condition.
I have 3 columns A, B and C
I want insert this condition:
IF A+B > C then A+B else 0
This formula work correclty in the table rows but not work in Grand Total .
May you help me to solved this issue?
Thanks in advance
Franco
Solved! Go to Solution.
You can create a new measure (not column) using DAX as follows:
Measure = IF(SUM(Data[A])+SUM(Data[B])>SUM(Data[C]);SUM(Data[A])+SUM(Data[B]);0)
You can create a new measure (not column) using DAX as follows:
Measure = IF(SUM(Data[A])+SUM(Data[B])>SUM(Data[C]);SUM(Data[A])+SUM(Data[B]);0)
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
63 |
User | Count |
---|---|
135 | |
126 | |
110 | |
70 | |
61 |