Forum Discussion
Drill based on Measure
Dear Friends
i have sample data as:
and
Powr BI have two pages: Main Page and Drill Page
created multiple measures by apply multiple filters on orginal data but for this sample data i creted three measures like:
Doc deleted = CALCULATE(COUNT(Sheet1[Doc status]),Sheet1[Doc status]="Deleted")
Doc received = CALCULATE(COUNT(Sheet1[Doc status]),Sheet1[Doc status]="Received")
Doc sent = CALCULATE(COUNT(Sheet1[Doc status]),Sheet1[Doc status]="Sent")
and hence Power BI(Main page) table with measure columns: Doc deleted, Doc received, Doc sent and Buyer Column as:
and apply drill through to Drill page as:
when i drill on Main page for Buyer1>Doc Deleted(Qty 2) , the Drill page contain like all row for Buyer1 as shown:
but i need the result that contain only Deleted doc for Buyer1 and same like Doc Sent, Doc received for individual buyer like:
how can i achieve this
Thanks
Jiya
1 Reply
- serpiva64
Solution Sage
