VAR with multiple return values

Question

hi im new to power BI and would like to learn how to return multiple values based on my matrix column (month, year, quarter, etc.)
i have dax that will return column total but it is only works for month, can anyone help me update this with Year and quarter?

thanks in advance!

%Total Units =

VAR CurrentMonth = MAX('Date'[MonthName])

RETURN

DIVIDE(SUM(SalesFact[Units]),

CALCULATE(SUM(SalesFact[Units]),FILTER(ALLSELECTED(SalesFact),RELATED('Date'[MonthName])=CurrentMonth)))

alanp514 · Answer

Hai&nbsp;Jonjon_99&nbsp;Can you please elaborate your question and what you are trying to achive and the expected output you are looking, if its possible please share pbix file using dummy data

jonjon_99 · Answer

hi Alan, thanks for checking. i want to have a table calculated by year.it works in monthly but not in yearly

jonjon_99 · Answer

result should be 100% aswell in yearly summary.

jonjon_99 · Answer

and this is the data.https://drive.google.com/drive/folders/1i7N8YWWwMvZHEU08rxWIRDBsaC_kz6sg

alanp514 · Answer

Hi&nbsp;Jonjon_99&nbsp;Thank for sharing , recieved the data, now please explain your expected output in detailed way ,What you are trying to achive , i am not geeting by reading your previous

Forum Discussion

VAR with multiple return values

9 Replies

Related content

Return multiple values

Measure to return multiple values

Measure returning incorrect value

Date Different return wrong value

LOOKUPVALUE with multiple return values