Forum Discussion

channah1's avatar
channah1
New Member
6 years ago
Solved

Data card tile - help

Hi there,    I created a checklist app for 4 pieces of machinery on power apps that pulls the information into 4 seperate sharepoint lists.  I used append feature to get them all on one bar chart ...
Need Help
  • v-alq-msft's avatar
    v-alq-msft
    6 years ago

    Hi, channah1 

     

    Based on your description, I created data to reproduce your scenario.

    Table:

     

    You may create two measures as follows.

     

    Percentage per day per machine = 
var _id = SELECTEDVALUE('Table'[ID])
var _num = SELECTEDVALUE('Table'[Checked number])
return
SWITCH(
    TRUE(),
    _id=1,_num/7,
    _id=2,_num/3,
    _id=3,_num/2,
    _id=4,_num/1
)

IsCompleted = 
var _date = SELECTEDVALUE('Table'[Date])
var _result =
SUMX(
    FILTER(
        ALLSELECTED('Table'),
        'Table'[Date]=_date
    ),
    [Percentage per day per machine]
)
return 
IF(
    _result=4,
    "Yes",
    "No"
)

     

     

    Finally you may use 'Multi-row card' visual to display the 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.

     

v-alq-msft's avatar
v-alq-msft
Community Support
6 years ago

Hi, channah1 

 

Based on your description, I created data to reproduce your scenario.

Table:

 

You may create two measures as follows.

 

Percentage per day per machine = 
var _id = SELECTEDVALUE('Table'[ID])
var _num = SELECTEDVALUE('Table'[Checked number])
return
SWITCH(
    TRUE(),
    _id=1,_num/7,
    _id=2,_num/3,
    _id=3,_num/2,
    _id=4,_num/1
)

IsCompleted = 
var _date = SELECTEDVALUE('Table'[Date])
var _result =
SUMX(
    FILTER(
        ALLSELECTED('Table'),
        'Table'[Date]=_date
    ),
    [Percentage per day per machine]
)
return 
IF(
    _result=4,
    "Yes",
    "No"
)

 

 

Finally you may use 'Multi-row card' visual to display the 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.