Show measure for some rows and not others

DAX DAX Calculations
1

Good day,

I would like to understand how I can show a measure for one dimension and not for others. Below is a model I have built to replicate an issue I am experiencing. When established, a matters budget is not specified for each charge type. We would like to see the total budget only at the matter name level but leave blank for the charge type row (so as to avoid confusion). With no relationship between budget and charge type the matters budget is repeated.

The [% of budget used TD] will still be needed at both the matter name and charge type level.

Example snip is below and a sample PBIX is attached demonstrating the issue.

Thanks
Malcolm

Row specific measure snip
Row specific measure snip563×705 33.3 KB

Power BI Measures for some rows and not others.pbix (57.7 KB)

2

@MalcolmJ ,

You can use the ISINSCOPE function to make quick work of this one:

Budget IsInscope =

IF(
    ISINSCOPE( 'Charge Type'[Charge Type] ),
    BLANK(),
    SUM( 'Matter Budgets'[Matter Budget] )
)

image

I hope this is helpful.

– Brian

https://info.enterprisedna.co/dax-function-guide/isinscope/

3

Hi @MalcolmJ.

(Brian beat me to it.) You can adjust your DAX to check for a single value for [Charge Type], for example using something like this (both ISINSCOPE and HASONEVALUE work):

Budget 2 =
IF(
    HASONEVALUE( 'Charge Type'[Charge Type] ),
    BLANK(),
    SUM( 'Matter Budgets'[Matter Budget] )
)


% of Budget Used TD 2 =
IF(
    HASONEVALUE( 'Charge Type'[Charge Type] ),
    BLANK(),
    DIVIDE( [Total Incurred], [Budget 2], 0 )
)

and get something like this:

eDNA Forum - Blank Budget at Detail Level 1
eDNA Forum - Blank Budget at Detail Level 12643×1695 420 KB

Hope this helps.
Greg

eDNA Forum - Blank Budget at Detail Level.pbix (58.4 KB)