Create Values based on 2 conditions
<p>How to create a values based on 2 conditions on <code>DAX</code></p>

<p>I want to create a value of 8 for each user and for each day.</p>

<p>So now if a user have 1 single event in 1 day the Value should be 8.</p>

<p>If a User have 5 events in a single day the value also should total 8, it can like the first event will be 8 and the rest will be null. </p>

<pre><code>USER    DATE            EVENT       VALUE
-------------------------------------------
Dan     2016-01-01      Event 1 
------------------------------------------- 
Nat     2016-01-01      Event 1 
Nat     2016-01-01      Event 2 
Nat     2016-01-01      Event 3 
Nat     2016-01-01      Event 4 
Nat     2016-01-01      Event 5 
-------------------------------------------
</code></pre>

<p>Expected Result</p>

<blockquote>
<pre><code>USER       DATE           EVENT          VALUE
-------------------------------------------
Dan       2016-01-01      Event 1         8
-------------------------------------------   
Nat       2016-01-01      Event 1         8
Nat       2016-01-01      Event 2 
Nat       2016-01-01      Event 3 
Nat       2016-01-01      Event 4 
Nat       2016-01-01      Event 5 
-------------------------------------------
</code></pre>
</blockquote>

<p>I am trying the query like </p>

<pre><code>=IF([USER] &amp; [DATE];8;0)
</code></pre>

<p>How to write this script on DAX or Excel !</p>

<p>Any one knows any solution to this problem !</p>