Measure doesn't show value if I use variable

[Giada_Togliatti]

Hi, 

I created a measure with some variable, the measure must show a value if there is something selected, instead it should show %

I've made similar formula with other database and it works, why now it shows always % also if I select something?

The formula is something like this:

masure=

var maxtime= max(field5)
VAR _sel1 =
    COUNTROWS ( ALLSELECTED ( 'field1) )
VAR _sel2 =
    COUNTROWS ( ALLSELECTED ( field2) )
RETURN
    IF (
        sel1 = 1
            &&  sel2= 1,
        CALCULATE (
          MAX(field3),
          [field5]= maxtime
          ),
        "%"
    )

Thank you

[v-alq-msft]

Hi, @Giada_Togliatti 

Based on your description, I created data to reproduce your scenario. The pbix file is attached in the end.

Table:

You may create a measure as below.

Mva = 
VAR maxtime= max('Table'[field1])
VAR _sel1 =
COUNTROWS (ALLSELECTED('Table'[field2]) )

VAR _sel2 =
COUNTROWS ( ALLSELECTED('Table'[field3]) )
RETURN
IF (
    _sel1 = 1&& _sel2= 1,
    CALCULATE(
          MAX('Table'[field5]),
          FILTER(
              ALL('Table'),
             'Table'[field4] ="chairs"&&
             'Table'[field1]=maxtime
          )
    ),
    "%"
)

Result:

Best Regards

Allan

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[andre]

ALLSELECTED does the opposite of what you want to do, if you want to see what's selected, i assume in slicers, then you should just use countrows on your table, whatever it counts, that what has been selected, distinict(columnName) will give you all the distinct values that have been selected

[Giada_Togliatti]

@andre , @Pragati11 , @amitchandak 

I tried to remove allselected but it gives me error, I tried to change allselected with distinct but it doesn't work, I see always %

field1	field2	field3	field4	field5
201806	string1	string4	chairs	5
201906	string1	string5	chairs	6
201806	string2	string6	table	9
201906	string3	string6	table	7

 field 2 and field3 are used in slicer

I shoud do a formula like this:

mwa=

VAR maxtime=
max(field1)
VAR _sel1 =
COUNTROWS (allslected( field2) )

VAR _sel2 =
COUNTROWS ( allselected( field3) )
RETURN
IF (
_sel1 = 1
&& _sel2= 1,

CALCULATE(max(field5),
[field4]="chairs",
[field1]=maxtime), "%")

[v-alq-msft]

Hi, @Giada_Togliatti 

If you take the answer of someone, please mark it as the solution to help the other members who have same problems find it more quickly. If not, let me know and I'll try to help you further. Thanks.

Best Regards

Allan

[amitchandak]

@Giada_Togliatti , I doubt there some mismatch at [field5]= maxtime

Can you share sample data and sample output in table format?

[Pragati11]

Hi @Giada_Togliatti ,

Just wanted to check why you are using ALLSELECTED in the measure? (highlighted)

masure=

var maxtime= max(field5)
VAR _sel1 =
    COUNTROWS ( ALLSELECTED ( 'field1) )
VAR _sel2 =
    COUNTROWS ( ALLSELECTED ( field2) )
RETURN
    IF (
        sel1 = 1
            &&  sel2= 1,
        CALCULATE (
          MAX(field3),
          [field5]= maxtime
          ),
        "%"
    )

Is ALLSELECTED your tablename?

Thanks,

Pragati

[Giada_Togliatti]

@Pragati11, allselected is the dax formula, in other situation it works, after allselected I used tablename(fieldname), I used allselected because I must consider the selection of field1 and field2 that are used in slicer

[Pragati11]

Hi @Giada_Togliatti ,

Try removing ALLSELECTED from your measure with COUNTROWS and test.

If it doesn't work, share some sample pbix file to check for the issue.

Thanks,

Pragati