Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello Team ,
I am creating DAX mesure as per my calculation Need , but i am not abel to Sum that measure , kindly help me on below dax.
DAX Measure - Measure 1 = IF('Revenue- 2021'[Value]<0,BLANK(),1)
i wanted just sum of all the if count wherever 1 is showing .
Below Matrix Table for your referance -
Client name | Revenue 2021 | Measure 1 |
ABC | 200 | 1 |
XYZ | 100 | 1 |
A | - | |
B | 100 | 1 |
Total | 400 | 3 |
I want just sum of my measure 1 - insted of 3 i am gatting 1 as a sum value kindly help me on this
Output - I want Measure 1 = totalsumeis 3 .
Thank you.
Solved! Go to Solution.
@SAPpowerbi , assuming this is a measure -'Revenue- 2021'[Value]
Countx(values(Table[Client name]), IF('Revenue- 2021'[Value]<0,BLANK(),[Client name]) )
Hi,
Please check the below picture and the attached pbix file.
Count measure greater than zero: =
SUMX (
ADDCOLUMNS (
VALUES ( Data[Client name] ),
"@conditionmeasure", CALCULATE ( IF ( [Rev 2021 measure:] <= 0, 0, 1 ) )
),
[@conditionmeasure]
)
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
@SAPpowerbi , assuming this is a measure -'Revenue- 2021'[Value]
Countx(values(Table[Client name]), IF('Revenue- 2021'[Value]<0,BLANK(),[Client name]) )
Thank you so much , this work for me .thnks alot God bless you .
Hi ,
Thank you for reply .
revenue 2021 value - is my column .
I am using this column and write this - Measure 1 = IF('Revenue- 2021'[Value]<0,BLANK(),1)
Kindly help me if Revnue 2021 is column than how to write in dax.
Thank you .
User | Count |
---|---|
98 | |
90 | |
83 | |
70 | |
67 |
User | Count |
---|---|
113 | |
104 | |
101 | |
73 | |
65 |