Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi! A problem I have seems to be light but strange obstacles occurred while I was trying to solve it, and so I am here asking for your help.
I have a table 'DB Stores' including contact information such as owners' names, phone numbers, contact emails, and trading status information - boolean fields meaning if a corresponding service is enabled or not, e.g. "PayOutsideEnabled". In my report, I need to show in the first table only stores that have at least one enabled service and in the second table stores with no services turned on. Moreover, I should filter the values by month in "LastUpdate" field, so, actually, these tables will show the last status changes.
I decided to write a measure with needed logic and 1/0 as output and then filter the tables by its result. The example below is a bit simplified version of my code. Actually, there are 9 enabled-ish variables.
...but if I change TRUE() to FALSE() in IF's condition, I will get
for all the stores I got with the previous function.
Any ideas on how I can fix my code or filter the tables? Thank you.
Hi @Anonymous ,
Try to modify your measure as below:
Table_TurnOn =
VAR BookingTableEnabled = FIRSTNONBLANK( 'DB Stores'[BookingTableEnabled], 1)
VAR TableOrderEnabled = FIRSTNONBLANK( 'DB Stores'[TableOrderEnabled], 1)
VAR result = AND( OR(BookingTableEnabled, TableOrderEnabled) = TRUE(), 1, 0)
RETURN
result
Best Regards,
Kelly
Did I answer your question? Mark my post as a solution!
Please be more specific when you say "table" - I get confused when you mean your source data table and when you mean your table visuals.
Please provide sample data in usable format (not as a picture) and show the expected outcome.
User | Count |
---|---|
141 | |
113 | |
104 | |
78 | |
64 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |