Forum Discussion
Need help in DAX.
I have different brands and clients with their respective YTD values of Revenue and Gross Profit.
Based on Revenue $ Change values I have written a DAX which shows Growth ( Positive Value = "Growing", Negative Value ="Declining", Zero="No Current Business")
I want to create a DAX which gives me the count of Only Growing Clients.
When I tried to create the same it is giving the error shown above.
Demo Data Table: DAX has to be calculated to get a growing count on Brand With Business Column.
| Client | Brand Name | AD Rev YTD 2021 | AD GP YTD 2021 | Brand With Business | Overall AD Rev Growth | Rev_$_Change | Rev % Change | Overall AD GP Growth | AD GP $ Change | AD GP % Change |
| Client 1 | Brand 1 | 66000 | 8000 | 1 | Growing | 22000 | 60.00% | Growing | 2800 | 50.00% |
| Client 1 | Brand 2 | 44000 | 9000 | 1 | Growing | 25000 | 105.00% | Growing | 3800 | 65.00% |
| Client 1 | Brand 3 | 0 | 0 | No Current Business | 0 | No Current Business | 0 | |||
| Client 1 | Brand 4 | 300 | 300 | 1 | Growing | 1600 | Growing | 1600 | ||
| Client 1 | Brand 5 | 1600 | 900 | 1 | Declining | -20 | -12.00% | Declining | -0.55 | -2.00% |
| Client 2 | Brand 1 | 120000 | 18000 | 1 | Declining | -30 | -0.10% | Growing | 620 | 44.00% |
| Client 2 | Brand 2 | 43000 | 9000 | 1 | Growing | 9000 | 30.00% | Growing | 1700 | 2.00% |
| Client 2 | Brand 3 | 0 | 0 | No Current Business | 0 | No Current Business | 0 | 26% | ||
| Client 2 | Brand 4 | 61000 | 47000 | 1 | Growing | 5000 | 16.00% | Growing | 1800 | 8.00% |
| Client 2 | Brand 5 | 0 | 0 | No Current Business | 0 | No Current Business | 0 |
Require OutPut: Brand with business showing count for only growing clients.
| Client | Brand Name | AD Rev YTD 2021 | AD GP YTD 2021 | Brand With Business | Overall AD Rev Growth | Rev_$_Change | Rev % Change | Overall AD GP Growth | AD GP $ Change | AD GP % Change |
| Client 1 | Brand 1 | 66000 | 8000 | 1 | Growing | 22000 | 60.00% | Growing | 2800 | 50.00% |
| Client 1 | Brand 2 | 44000 | 9000 | 1 | Growing | 25000 | 105.00% | Growing | 3800 | 65.00% |
| Client 1 | Brand 3 | 0 | 0 | No Current Business | 0 | No Current Business | 0 | |||
| Client 1 | Brand 4 | 300 | 300 | 1 | Growing | 1600 | Growing | 1600 | ||
| Client 1 | Brand 5 | 1600 | 900 | Declining | -20 | -12.00% | Declining | -0.55 | -2.00% | |
| Client 2 | Brand 1 | 120000 | 18000 | Declining | -30 | -0.10% | Growing | 620 | 44.00% | |
| Client 2 | Brand 2 | 43000 | 9000 | 1 | Growing | 9000 | 30.00% | Growing | 1700 | 2.00% |
| Client 2 | Brand 3 | 0 | 0 | No Current Business | 0 | No Current Business | 0 | 26% | ||
| Client 2 | Brand 4 | 61000 | 47000 | 1 | Growing | 5000 | 16.00% | Growing | 1800 | 8.00% |
| Client 2 | Brand 5 | 0 | 0 | No Current Business | 0 | No Current Business | 0 |
Thank you in Advance.
1 Reply
Please provide sanitized sample data in usable format (not as a picture - inserting it into a table would be good) and show the expected outcome.
