Conditional Subtotals

[vividarinda]

Hi Experts,

 I am novice to power bi and struggling with conditional subtotals of specific value. For example : On subtotals only total from major fleet and small fleet, not all values.

[Ashish_Mathur]

Hi,

Share the download link of the PBI file.

[amitchandak]

@vividarinda , Assume Major fleet is in column C1 and you measure is in use is m1

Then have to change the total

Switch(true() ,

isinscope(Table[C1]), [M1],

calculate([M1], filter(Allselected(Table[C1]), Table[C1] ="Major fleet"))

How to Switch Subtotal and Grand Total in Power BI | Power BI Tutorials| isinscope: https://youtu.be/smhIPw3OkKA

Percent of Total and Percent of SubTotal https://www.youtube.com/watch?v=6jTildcV2ho
https://www.youtube.com/watch?v=cN8AO3_vmlY&t=24270s

[vividarinda]

Hi @amitchandak ,

Thanks for prompt response Amitchandak.

But i have get error like this. 

[Anonymous]

HI @vividarinda,

I think the issue should be related the expression structures, the marked right brackets should be placed to the end of the formula. (it seems like you have broken the calculate function usages)

Regards,

Xiaoxin Sheng