Grand total columns - using dynamic measures (selecting within slicer)

[Anonymous]

Hi Power BI community,

since several days I struggle with the problem of calculating total values per each column. I have created dynamicaly selected measures using slicer. The problem relates to the total values. There is just one column which descibes total values, becasure I have used a measure with switch function inside (this way we are able to select measures within the slicer). The below two screenshots depict the described situation.

Is it possible to add grand total columns per each measure in the actual situation?

Kind regards,

Nicr

[v-shex-msft]

Hi @Anonymous ,

Please share a pbix file with some sample data to help us clarify your data structure and test to coding formula on it.

Notice: do mask on sensitive data.

Regards,

Xiaoxin Sheng

[Anonymous]

Hi @v-shex-msft,

I attach the pbix file with the current problem I struggle with.

Link: PBIX report

Kind regards,

Nicr

[Anonymous]

@v-shex-msft 

Any updates?

Kind regards,

Nicr

[v-shex-msft · Accepted solution]

Hi @Anonymous ,

Actually, total level is based on value fields, you can't use measure to split column fields on total level. You can consider to move one column field to row level and use row level total to instead:

dyn_measure = 
SWITCH(
    SELECTEDVALUE(dyn_values[ID]),
    1, FORMAT([V1], "#,##0"),
    2, FORMAT([V2], "#,##0"),
    FORMAT([V1]+[V2], "#,##0")
)

Regards,

Xiaoxin Sheng

[Anonymous]

@v-shex-msft 

Thanks for your help. The solution is ok, but doesn't fullfill my requirements at all, but if I have any simpler problem I won't hesitate to use it.

Kind regards,

Nicr