Show a different level of detail

[dcrios]

Hello everybody,

I was looking in the forum about something like LOA in Tableau, that aggregates a measure in diferents levels. But I think I'm missing something in Power BI, because I just wanted to show the sum of Clients in a new measure using "qtd" with the values that are not blank. So that measure will show only a value 39, because its on level of Client. Has someone faced something that solves this question? Thanks in advance

[v-chuncz-msft · Accepted solution]

@dcrios,

You may refer to the measure below.

Measure =
SUMX ( FILTER ( Table1, NOT ( ISBLANK ( Table1[Cliente] ) ) ), Table1[qtd] )

[dcrios]

Thank you very much. It really helps me