The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hi All,
I tried looking at various posts here to see if someone had similiar ask, but coudnt find one that really fits, but if its something i missed please refer me to the post happy to review it.
Herewith my query: I have created a Measure as follows:
Solved! Go to Solution.
Ok, i tweeked it a bit, since I was working with 2 tables. 1 table was Equipment which i used to display the equipment related to my Cost which was in the HanaOrderActualCost Table. So i just brought the equipment column into my HanaOrderACtualCost table since it was related and modified the measure as follows:
Hi @Fowmy
Thanks for your response, however this I have tried but it seems to count all the entries for this, and i need the unique count for the equipment. So i have a measure to do unique count on the equipment as that is a link to another table.
@Leyli_ON
You can try this way:
Count_OffMarc_Rows =
COUNTROWS(
FILTER(
'Hana Order Acutal Cost',
'Hana Order Acutal Cost'[Cost Element] <> "0000555090"
&& RELATED('Hana Equipment Additional Data'[Equipment F/L]) = "1200-MO-0215-M020-001"
)
)
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
Ok, i tweeked it a bit, since I was working with 2 tables. 1 table was Equipment which i used to display the equipment related to my Cost which was in the HanaOrderActualCost Table. So i just brought the equipment column into my HanaOrderACtualCost table since it was related and modified the measure as follows:
Not working, need distinc counts
User | Count |
---|---|
27 | |
12 | |
8 | |
8 | |
5 |
User | Count |
---|---|
31 | |
15 | |
12 | |
11 | |
7 |