Hi Everyone...
I used a conditional measurement for my matrix.
SWITCH(TRUE(),
SELECTEDVALUE(SELECTEDVALUE('Calendar'[month]) >= actual_Month, forecast_Value, actual_Value)
)
)
My intention is to show the actual value for months before the actual month and the forecast values for the upcoming months. The problem is on total, because the total column brings only the sum of the actual_Value instead of bringing the total sum of all twelve columns.
Note: if you sum the 4 initial months, won't match the total on Total column because there is actual value in May as well, though it won't show the May actual value, the total amount is considering it on the total column
Comments
-
v-xiaoyan-msft
on:
Fabric Error Logs - Mirror - Running with Warnings
-
v-xiaoyan-msft
on:
Data AzureDevops problem
- MHW on: Conditional Formatting GUI bug is preventing editi...
-
v-junyant-msft
on:
Polish province 'Lubuskie' bug in Map
-
gujralh
on:
Export Matrix visual through power automate
-
v-junyant-msft
on:
Exceções de uma tarefa não foram observada
-
v-junyant-msft
on:
Semantic Model and Report Syncing Issues with Git ...
-
michaelu1
on:
New Slicer Visual Eraser and Alert toggle missing
-
v-junyant-msft
on:
Cannot get the newest files from Sharepoint Folder...
-
v-junyant-msft
on:
How to Dock Tiles on Power BI Dashboard
Hi @wemersontm ,
Please provide sample data in a usable form, as well as your expected results.
Best regards,
Community Support Team_ Scott Chang