Dyanamic Dimension from measure in power bi

[Vikram1]

if I have a three Table
1. Dim_Customer : joiningDate, LeavingDate, State, District, Cust_Type, CustID, CustomerName
2. Dim_Date : All Possible Column like Date, Year, Month, Quarter etc..
3. Fact_Sales : CustID, InvoiceDate, SalesAmt

need soluation like :
when i select 3 months from slicer then i need to create column :  (Fact_Sales[SalesAmt]/(Number_of_Month Selected)) and create bucket like 0-100, 100-200, 200-500 etc. Group by with CustomerName/CustID and Customer count in bucket which we have created.

Need to show in Matrix

Row = State, City 

Column = Bucket

Value = Distinct Count of CustID

Dyanamic Dimension

[v-yuezhe-msft]

@Vikram1,

Please share sample data of your table and post expected result based on the sample data here.

How to Get Your Question Answered Quickly


Regards,
Lydia

[Vikram1]

please send your email id so i can send excel file with code and requirement detail. here i am not able to attach

[Vikram1]

My Email ID is vikram.jain@bitscape.com

[Vikram1]

Please Find Input output Detail of my Issue "Dyanamic Dimension from measure in Power BI "

https://www.dropbox.com/s/n8hrbv6sncgnquk/Copy%20of%20Issue%20Dynamic%20dimension.xls?dl=0

Thanks

Vikram