Forum Discussion

BieBel's avatar
BieBel
Icon for Helper I rankHelper I
1 year ago

Calculated measure by row I cannot get it to work ...

I have to calculate the room surfaces for different room types => RM[RM_CAT] is not BATHROOM or BASEMENT. I got the measure to 'work' as far as the roomtypes, but I need to (re)group the total surfa...
Need Help
BieBel's avatar
BieBel
Icon for Helper I rankHelper I
1 year ago
rm_type(Multiple Items)
  
Row LabelsSum of area
00089,89
0013302,75
00141,58
00157,8
0016992,73
0018566,51
0024307,39

  rm_type has been filtered in this pivot

  • Thejeswar's avatar
    Thejeswar
    Icon for Super User rankSuper User
    1 year ago

    Hi BieBel ,

    As I understand, you want data in details for all room types except Basement and Bathroom while your total needs to be at bl_id with all rooms considered.

    You can use the below DAX to get it

     

     

    RoomArea = IF(ISINSCOPE(Table1[rm_type]), CALCULATE([TotalArea], FILTER(Table1, AND(Table1[rm_type] <> "BASEMENT", Table1[rm_type]<>"BATHROOM"))), IF(ISINSCOPE(Table1[bl_id]), CALCULATE ( [TotalArea], ALLEXCEPT ( 'Table1', 'Table1'[bl_id] ) )))

     

     

    TotalArea = SUM(Table1[area])

     

     

    If this solves your question, mark it as solution and appreciate with a Kudo !

     

    Regards,