Forum Discussion
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 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
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
5 Replies
Hi Anonymous,
I attach the pbix file with the current problem I struggle with.
Link: PBIX report
Kind regards,
Nicr