Forum Discussion
Need help in DAX
Hi Guys , Need help on DAX ( May be using IF condition or anything else ) I have the above transaction in 1 table . Condition is - As you can see for 1 ID we have mutiple Status summary...
I'm not following 100% on what you have written, however its likely you need to use the DISTINCTCOUNT function.
If you are trying to get a count of IDs, irrespective of how many status' they have, you can do the DISTINCTCOUNT on the ID column.
If you are trying to get a count of IDs, but only count each status once, then you can do a DISTINCTCOUNT on the two fields concatinated. You would just need to create a field that uses the formula 'YourTable'[ID] & 'YourTable'[Status Summary]