Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

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

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...
Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    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's avatar
Anonymous
Not applicable
7 years ago

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's avatar
Anonymous
Not applicable
7 years ago

Anonymous 

 

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