Forum Discussion

itm007's avatar
itm007
New Member
7 years ago

Power bi what if analysis

New to DAX

 

I have a matrix power bi visualization which is like

             Jan Feb Mar April
Client1 10 20 30 10
Client2 15 25 65 80
Client3 66 22 54 12

I have created 3 what if parameters slicer table (having value from 1 to 4) for each client

For example If the value of first slicer is 1 and second is 2 and third is 2 then I want

 

           Jan Feb Mar April
Client1 0 20 30 10
Client2 0 0 65 80
Client3 0 0 54 12

that is it should replace the value with zero. I have been able to achieve that for one client using Dateadd function (by adding month)

Measure 1= MIN(Client Name) which gives me Client1 and then I have if(Measure1 ="Client1)) then use measure 2

Measure 2= CALCULATE(SUM('Table'[Value]),DATEADD('Table'[Column],Parameter[Parameter Value],MONTH))

 

and I have used this measure to display the value, but how to make it work for other two clients as well

2 Replies