topic Re: DAX formula in DAX Commands and Tips

DAX formula

MiMich — Thu, 01 Aug 2024 09:13:57 GMT

Hello everybody,

Here is the situation :

I've got a table like this :

I'd like to build this matrix in Power BI:

There is also a filter on the client.

So if I select for example client A the matrix must be :

Please could you help me.

Thanks all.

Re: DAX formula

BeaBF — Thu, 01 Aug 2024 10:01:14 GMT

MiMich Hi! Here the measure to achieve the result:

EventPercentage =

VAR SelectedYear = SELECTEDVALUE('Table'[Year])

VAR SelectedCategory = SELECTEDVALUE('Table'[Category])

VAR SelectedTypeEvent = SELECTEDVALUE('Table'[Type Event])

VAR SelectedClient = SELECTEDVALUE('Table'[Client])

VAR TotalEvents = CALCULATE(SUM('Table'[#Event]), 'Table'[Category] = SelectedCategory, 'Table'[Year] = SelectedYear, ALL('Table'[Type Event]))

VAR TotalEventsByYearAndType = CALCULATE(SELECTEDVALUE('Table'[#Event]), 'Table'[Category] = SelectedCategory, 'Table'[Year] = SelectedYear, 'Table'[Type Event] = SelectedTypeEvent, 'Table'[Client] = SelectedClient)

VAR CALC =

IF(

TotalEvents = 0,

BLANK(),

DIVIDE(TotalEventsByYearAndType * 100, TotalEvents * 100, 0)

)

RETURN CALC

also interacts with client slicer:

if it's oki, please accept my answer as solution.

BBF

Re: DAX formula

sjoerdvn — Thu, 01 Aug 2024 12:24:42 GMT

en % Magasin vs Web = VAR v = CALCULATE(SUM(Table[#ventes]), ALL(Table[Type vente])) RETURN IF(v, DIVIDE(SUM(Table[#ventes]),v))